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

190 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
doomily133613(None) 
roomily1237281roomily
boozily2135622boozily
doily95321032d_o_ily
dooly94821802doo__ly
doomier103610122doomier
dooming113112532dooming
doomy116018262doom__y
dopily123510462d_opily
dottily1147282dottily
dowdily1534952dowdily
dozily19329102d_ozily
droopily1443942droopily
foamily1546542foamily
gloomily1443752gloomily
goofily14105352goofily
homily144712332_homily
loonily1037072loonily
loopily1236802loopily
moodily1358202moodily
moonily1248942moonily
oozily18328072_oozily
sootily101810512sootily
woozily2234382woozily
anomaly1238843anomaly
balmily14216463balmily
beamily1477393beamily
bloodily1445183bloodily
bodily12310993_bodily
bonnily1236873bonnily
boomier113312183boomier
booming123716223booming
boomingly1744793boomingly
boomy125421823boom__y
bossily1237563bossily
boxily1877843_boxily
broodily1445503broodily
cockily1838493cockily
comely134213733_comely
comity13312713_comity
comply152810383_comply
coolly114811393coo_lly
cooly105525423coo__ly
cornily12410853cornily
cosily113613853_cosily
cozily20349703_cozily
daffily1735133daffily
daily95922333d__aily
damply14337893d_amply
dandily12279633dandily
daylily1434983daylily
dewily1338343d_ewily
dhooly13457143dho_oly
dimity12310473d_imity
dimly114913483d_im_ly
dimply14339743d_imply
dingily1238103dingily
dirtily1138583dirtily
dizzily1934843dizzily
docile94213123d_ocile
dolly96125203d_o_lly
dolomite1148123dolomite
domal85619203d_omal_
domic104317243d_omi_c
domine92918253d_omine
doming104218393d_oming
domino92611493d_omino
doobie94712683doobi_e
doobies103915673doobies
doodies94218773doodies
doodle83212853doo_dle
doody105517913doo__dy
doolie73916833dooli_e
doolies83920713doolies
doom76430073doom___
doomed104113293doom_ed
doomful1343663doomful
doomfully1852853doomfully
doomiest112910453doomiest
dooms85321343doom__s
doomsday1542003doomsday
doorsill943763doorsill
doorway1444243doorway
doozie163910643doozi_e
doozies173812723doozies
doozy186813713doo__zy
dormice1237133dormice
dormie9312623dormi_e
dormin9312313dormi_n
dormins10311273dormins
dormy115817463dorm__y
dossil75110903dossil_
dossils8669773dossils
doubly12328963d_oubly
doucely1344883doucely
dourly103210433d_ourly
doyly124514013d_o_yly
dreamily1435143dreamily
drily95816523d__rily
drolly105411673dro_lly
drooly104911073dro_oly
drowsily1583723drowsily
drumly1235703drum_ly
dumbly14399603d_umbly
dumpily1566233dumpily
duomi8310133duomi__
duopoly1343683duopoly
duskily15236743duskily
dustily113211523dustily
family143311703_family
filmily1535733filmily
foggily1535053foggily
foxily1947253_foxily
gamily123712183_gamily
gemmily1534603gemmily
godlily1235343godlily
goodly11419303goo_dly
googly11417883goo_gly
goombay1543553goombay
gorily10612503_gorily
goutily1137933goutily
grimily1336523grimily
hammily1736063hammily
hoarily1338973hoarily
hokily16409093_hokily
holily123612953_holily
homely145313173_homely
hominy144511483_hominy
hooly115022223hoo__ly
hornily1338283hornily
horsily1338843horsily
jokily20306533_jokily
jollily1745773jollily
joltily1746323joltily
loftily1336353loftily
logily1039833_logily
looming102814853looming
loosely1036713loosely
lousily1038333lousily
lowlily1335353lowlily
mousily1239393mousily
nobbily1436693nobbily
noily86120993_no_ily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683_nosily
oilily93111723_oilily
oily77932253__o_ily
oomiac1037063_oomiac
oomiak1235353_oomiak
phonily1537103phonily
pockily1846233pockily
podgily1435213podgily
pokily15309063_pokily
poorly1137893poo_rly
prosily12611633prosily
roily86121113_ro_ily
roomie83013873roomi_e
roomier93812243roomier
roomies93017243roomies
rooming104117043rooming
roomy107118063room__y
ropily113312443_ropily
rosily93914713_rosily
roupily1246653roupily
rowdily1436083rowdily
showily1636213showily
slimily1247713slimily
smokily1635373smokily
snoopily1345553snoopily
snootily1136243snootily
snowily1336883snowily
soapily1237963soapily
soggily1235953soggily
soothly13186913soothly
sorrily1039823sorrily
soymilk1642363soymilk
spookily1744173spookily
spoonily1335233spoonily
stonily1049433stonily
stormily1345243stormily
toothily1445523toothily
woollily1443123woollily
woolly12408513woo_lly
wooly114417673woo__ly
wordily1437853wordily
wormil1138043wormil_
wormils1236733wormils
zooming19269653zooming
zoophily2544913zoophily

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 Limit1340271906.97019229.1
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.18924856.2
 
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.