Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “loftily” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

205 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
loftily133635(None) 
dottily1147282dottily
goutily1137932goutily
heftily1635762heftily
joltily1746322joltily
loathly1334712loathly
loftier1037762loftier
lofting113311312lofting
lofty115813302loft__y
logily1039832lo_gily
loonily1037072loonily
loopily1236802loopily
lousily1038332lousily
lowlily1335352lowlily
lustily103611242lustily
niftily1335752niftily
softly12457762soft_ly
sootily101810512sootily
tuftily1335572tuftily
artily92814713_artily
bloodily1445183bloodily
blousily1345193blousily
blowsily1643953blowsily
blowzily2542733blowzily
bodily12310993bo_dily
bonnily1236873bonnily
boozily2135623boozily
bossily1237563bossily
botfly1436093bo_tfly
boxily1877843bo_xily
cattily123210853cattily
cloggily1543243cloggily
cloudily1444283cloudily
cockily1838493cockily
cornily12410853cornily
cosily113613853co_sily
costly114012333cost_ly
cozily20349703co_zily
craftily1644783craftily
daffily1735133daffily
daftly1335443daft_ly
deftly1336533deft_ly
dirtily1138583dirtily
doily95321033do__ily
doomily1336133doomily
dopily123510463do_pily
dowdily1534953dowdily
dozily19329103do_zily
draftily1534413draftily
dustily113211523dustily
emptily1445813emptily
fattily13379463fattily
fifthly1943093fifthly
fitly115114973__fitly
flintily1434893flintily
floppily1843773floppily
flossily1434523flossily
fluffily1652923fluffily
foamily1546543foamily
foggily1535053foggily
fortify1636523fortify
foxily1947253fo_xily
frostily1436693frostily
fustily133111373fustily
gloomily1443753gloomily
glossily1235093glossily
godlily1235343godlily
goofily14105353goofily
gorily10612503go_rily
gustily113010903gustily
hastily133010663hastily
hoarily1338973hoarily
hokily16409093ho_kily
holily123612953ho_lily
homily144712333ho_mily
hornily1338283hornily
horsily1338843horsily
hostile10312553hostile
hostly124210863host_ly
hotly115815473ho_t_ly
huffily1934693huffily
jokily20306533jo_kily
jollily1745773jollily
knottily1543153knottily
lacily11612763l_acily
laithly1335653laithly
lankily1437123lankily
lastly93310873last_ly
lately93413843l_ately
lazily1859713l_azily
leakily1436473leakily
leerily1037633leerily
lefties10312073lefties
leftish13197253leftish
leftism12226093leftism
leftist10279353leftist
lefty115613563left__y
lentil64315393lentil_
lentils73912973lentils
licitly12276673licitly
lifting113313273lifting
lily76730183l___ily
lobately1344013lobately
locally12179723locally
loft76539143loft___
lofted103811893loft_ed
lofter94614723loft_er
lofters103912903lofters
loftiest1139083loftiest
loftlike1534393loftlike
lofts85518363loft__s
lolly85120663lo__lly
lonelily1144973lonelily
lonely92912463lo_nely
longly10279603lo_ngly
loosely1036713loosely
looting83019643looting
lordly1038753lo_rdly
loti46431833lo_ti__
lotic76420663lo_ti_c
lotion65716523lo_tion
lottery10389823lottery
lotting82917753lotting
loudly1037783lo_udly
louting83719383louting
loutish1039963loutish
loutishly1543743loutishly
lovably15187063lovably
lovelily1444333lovelily
lovely12339713lo_vely
loverly1346963loverly
lowly114113333lo__wly
loyally13126843loyally
luckily16297083luckily
lumpily1476563lumpily
meatily12311093meatily
mistily122612343mistily
monthly1535673monthly
moodily1358203moodily
moonily1248943moonily
mortify1536223mortify
mostly113110943most_ly
motile83818343mo_tile
mousily1239393mousily
mouthily1645903mouthily
mustily123613633mustily
nastily103011033nastily
nattily103610323nattily
nobbily1436693nobbily
noily86120993no__ily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683no_sily
notify1236943no_tify
nuttily10308633nuttily
oilily93111723_oilily
oily77932253_o__ily
oozily18328073_oozily
outfly1238273_outfly
pettily1238173pettily
pockily1846233pockily
podgily1435213podgily
pokily15309063po_kily
pontil8315463pontil_
pontils9312213pontils
portly114713403port_ly
puffily1834843puffily
roily86121113ro__ily
roomily1237283roomily
ropily113312443ro_pily
rosily93914713ro_sily
roupily1246653roupily
rowdily1436083rowdily
rustily103112993rustily
ruttily10338613ruttily
saltily10310543saltily
shiftily1744543shiftily
sloppily1544613sloppily
snootily1136243snootily
snottily1145543snottily
soapily1237963soapily
softie93312473softi_e
softies103414613softies
softish13127813softish
softy115414483soft__y
soggily1235953soggily
soothly13186913soothly
sorrily1039823sorrily
sportily1337733sportily
spottily1335143spottily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
testily102910803testily
toothily1445523toothily
toploftily1851083toploftily
tortile7313193tortile
unfitly1335573unfitly
wittily1336173wittily
wofully1644523wofully
woozily2234383woozily
wordily1437853wordily
worthily1745253worthily
zestily19167563zestily
zoftig1932973zofti_g

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit1340272057.36018210.2
3Display Results2052050.0603416.7
 (SQL Overall)1786912057.57623586.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.