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 “loopily” 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.

194 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
loopily123680(None) 
loonily1037071loonily
bloodily1445182bloodily
boozily2135622boozily
doomily1336132doomily
dopily123510462_dopily
droopily1443942droopily
floppily1843772floppily
gloomily1443752gloomily
goofily14105352goofily
loftily1336352loftily
logily1039832l_ogily
loopier93711192loopier
looping103615282looping
loopy105316642loop__y
loosely1036712loosely
lousily1038332lousily
lowlily1335352lowlily
lumpily1476562lumpily
moodily1358202moodily
moonily1248942moonily
oozily18328072_oozily
roomily1237282roomily
ropily113312442_ropily
roupily1246652roupily
sloppily1544612sloppily
snoopily1345552snoopily
soapily1237962soapily
sootily101810522sootily
woozily2234382woozily
zoophily2544912zoophily
aloofly1343623aloo_fly
blooping13248843blooping
blousily1345193blousily
blowsily1643953blowsily
blowzily2542733blowzily
bodily12310993_bodily
bonnily1236873bonnily
bossily1237563bossily
boxily1877843_boxily
broodily1445503broodily
bumpily1665653bumpily
campily1638273campily
choppily2044133choppily
cloggily1543243cloggily
cloudily1444283cloudily
cockily1838493cockily
compile13312443compile
comply152810383comp_ly
coolly114811393coo_lly
cooly105525423coo__ly
coopery143910273coopery
cooping123918933cooping
cornily12410853cornily
cosily113613853_cosily
cozily20349703_cozily
croupily1544743croupily
doily95321033_do_ily
dooly94821803doo__ly
dottily1147283dottily
dowdily1534953dowdily
dozily19329103_dozily
dumpily1566233dumpily
duopoly1343683duopoly
eolopile1045863eolopile
flossily1434523flossily
foamily1546543foamily
foggily1535053foggily
foxily1947253_foxily
glossily1235093glossily
glumpily1643593glumpily
godlily1235343godlily
goodly11419303goo_dly
googly11417883goo_gly
goopier103910573goopier
goopy115816623goop__y
gorily10612503_gorily
goutily1137933goutily
happily1745763happily
hoarily1338973hoarily
hokily16409093_hokily
holily123612953_holily
homily144712333_homily
hooly115022223hoo__ly
hooping133615703hooping
hoopla1147633hoop_la
hornily1338283hornily
horsily1338843horsily
jokily20306533_jokily
jollily1745773jollily
joltily1746323joltily
jumpily2174983jumpily
lacily11612763l_acily
lankily1437123lankily
lazily1859713l_azily
leakily1436473leakily
leerily1037633leerily
lily76730183l___ily
limpidly1643153limpidly
limply133810033limp_ly
loathly1334713loathly
locally12179723locally
logophile15115103logophile
lolly85120663l_o_lly
lonelily1144973lonelily
lonely92912473l_onely
longly10279603l_ongly
loobies93814103loobies
looby108115623loo__by
looey84822913loo__ey
looie55624243loo_i_e
looies65025833loo_ies
looing73621043loo_ing
looking123415043looking
lookism1335913lookism
lookist1139563lookist
looming102814853looming
looney94712413loo_ney
loonie64216453looni_e
loonier73312683loonier
loonies73919543loonies
loony86918963loo__ny
loop67835013loop___
looped95217173loop_ed
looper83817113loop_er
loopers93914033loopers
loophole1358633loophole
loopiest103011313loopiest
loops75723963loop__s
loosing83515963loosing
looting83019643looting
loping93921413l_oping
loppier11369723loppier
lopping123815223lopping
loppy125911663l_op_py
lordly1038753l_ordly
loudly1037783l_oudly
louping104313983louping
lovably15187063lovably
lovelily1444333lovelily
lovely12339713l_ovely
loverly1346973loverly
lowly114113333l_o_wly
loyally13126843loyally
luckily16297083luckily
lustily103611243lustily
lyophile1645963lyophile
monopoly1546823monopoly
mousily1239393mousily
nippily1444713nippily
nobbily1436693nobbily
noily86120993_no_ily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683_nosily
oilily93111723_oilily
oily77932253__o_ily
peppily1335133peppily
phonily1537103phonily
pily96132733___pily
pockily1846233pockily
podgily1435213podgily
pokily15309063_pokily
pooping123615443pooping
poorly1137893poo_rly
prosily12611633prosily
pulpily1436103pulpily
roily86121113_ro_ily
rosily93914713_rosily
rowdily1436083rowdily
sappily1437163sappily
showily1636223showily
sleepily1344823sleepily
slippily1544193slippily
smokily1635373smokily
snootily1136253snootily
snowily1336883snowily
soggily1235953soggily
soothly13186923soothly
sorrily1039833sorrily
spookily1744173spookily
spoonily1335233spoonily
stonily1049433stonily
toothily1445523toothily
torpidly1483653torpidly
toxophily2443123toxophily
waspily1535513waspily
wispily1535653wispily
woodpile1444093woodpile
woollily1443123woollily
woolly12408513woo_lly
wooly114417673woo__ly
wordily1437853wordily
zoophile2246453zoophile

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.406440125.6
2DLD Change Limit1340271946.75019855.9
3Display Results1941940.0603233.3
 (SQL Overall)1786911947.21624763.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.