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

216 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
gormless1123544(None) 
formless13248081formless
normless10235921normless
armless9369942_armless
cordless11299962cordless
coreless103013832coreless
foamless13195842foamless
fordless12289002fordless
forkless15267432forkless
garbless11388252garbless
goalless935722goalless
godless938402go_dless
goriness9310752goriness
gumless10228272g_umless
harmless1337402harmless
hornless1137362hornless
loamless10235212loamless
lordless9277482lordless
orbless937492_orbless
portless10310642portless
termless1036232termless
wordless12258842wordless
workless15276802workless
aimless93610813_aimless
airless73712043air_less
armlets94610063_armlets
artless73712513_artless
barbless12318713barbless
barkless14318023barkless
barless94317003bar_less
beamless12327003beamless
bloomless1342963bloomless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boomlets12246673boomlets
boonless10328353boonless
bootless103410983bootless
bowless123310313bo_wless
braless92910563_braless
brimless1235273brimless
browless1346653browless
careless102813633careless
carless95118493car_less
charmless1633583charmless
coalless1038193coalless
coatless1039693coatless
codeless112010113codeless
cookless14258633cookless
cormels113813373corm_els
corslets1038273corslets
corulers1039773corulers
costless10310003costless
coxless1637743co_xless
cropless1237793cropless
cureless10319703cureless
doorless936713doorless
dormers104313923dorm_ers
downless1236363downless
earless74316073ear_less
egoless836983ego__less
fernless1136063fernless
filmless1344553filmless
fireless112810593fireless
firmness1334743firmness
fogless1138193fo_gless
foodless12338383foodless
footless113710803footless
forceless1435723forceless
forelegs1236613forelegs
formalness1544833formalness
formers128217953form_ers
formes114623713form_e_s
formlessly1842953formlessly
fortress1136753fortress
furless103210143fur_less
gainless9117403gainless
gapless10349993g_apless
garblers113810283garblers
garbles104016923garble_s
garglers10418263garglers
gargles94214893gargle_s
gasless8319013g_asless
gateless9279953gateless
gearless937373gearless
germens1078623germ_ens
germiest11249913germiest
germiness1257693germiness
giftless1245173giftless
gimlets10338433g_imlets
girdlers10195403girdlers
girdles92210003girdle_s
glumness1135203glumness
gobblers13308343gobblers
gobbles123512583gobble_s
goblets103210183go_blets
goddess1035263go_ddess
gogglers11276713gogglers
goggles103510793goggle_s
goglets9379783go_glets
golems939323go__lems
gomers94116883go_m_ers
goneness9310763goneness
goodness1036253goodness
gorals76917653goral__s
gores65740373gor__e_s
gorgers94813643gor_gers
gorges85321893gor_ge_s
gorgets94711783gor_gets
gorhens1137183gor_hens
goriest82218743gor_iest
gorillas946373gorillas
gormands1266563gormands
gormed105013833gorm_e_d
gorms85619593gorm___s
gorses74723293gor_se_s
gorsiest92511133gorsiest
gourmets1144153gourm_ets
grilses8319153g_rilses
grimness1175993grimness
grommets13234663grommets
groveless13235363groveless
growlers12327093growlers
gunless8299633g_unless
gurgles94312873gurgle_s
gurglets10355543gurglets
gustless9287683gustless
gutless82610713g_utless
helmless1334273helmless
herbless1336663herbless
holeless1189363holeless
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
horseless1237213horseless
hurtless11307783hurtless
ireless72312243_ireless
jobless16237563jo_bless
joyless17226513jo_yless
juryless1832983juryless
kermess13396223kerm_ess
kirmess13234313kirm_ess
loftless1135903loftless
lornness836493lornness
lossless835473lossless
loveless1168573loveless
moonless10278043moonless
morales93619403morale_s
moreness10911573moreness
moveless1367753moveless
noseless839513noseless
noteless839403noteless
nounless837253nounless
oarless73913373_oarless
odorless934173odor_less
ogress7529503ogr__ess
orles55326213_or_le_s
ormers84316143_orm_ers
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
portress1038323portress
rimless9369363_rimless
roadless937703roadless
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
scoreless1155603scoreless
scumless1254993scumless
seamless10238723seamless
shoreless1236633shoreless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sonless72612613so_nless
soreness8914793soreness
soulless8218763soulless
soupless10268463soupless
stemless1036653stemless
sumless92611123_sumless
thornless1243633thornless
tireless82510263tireless
toadless936313toadless
toeless72612393to_eless
tombless1236783tombless
toneless8610393toneless
toolless836343toolless
topless92511123to_pless
townless1135653townless
toyless10268713to_yless
tramless1037503tramless
turfless1135533turfless
verbless1336033verbless
voteless1137493voteless
vowless13246603vo_wless
wardless12249303wardless
warless104015103war_less
warmness1337063warmness
wartless11279923wartless
wireless11249633wireless
woodless12278453woodless
wormers124012573worm_ers
wormiest13249543wormiest
worminess14127613worminess
wornness1136363wornness
worthless1544923worthless
yokeless1535303yokeless
zoneless1737823zoneless

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622166.59322169.3
3Display Results2162160.0932322.6
 (SQL Overall)1786912167.09225196.1
 
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.