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

265 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
formless1324808(None) 
foamless13195841foamless
fordless12289001fordless
forkless15267431forkless
gormless11235441gormless
normless10235921normless
armless9369942_armless
cordless11299962cordless
coreless103013832coreless
fernless1136062fernless
filmless1344552filmless
fireless112810592fireless
firmness1334742firmness
fogless1138192fo_gless
foodless12338382foodless
footless113710802footless
forceless1435722forceless
forelegs1236612forelegs
formalness1544832formalness
formers128217952form_ers
formes114623712form_e_s
formlessly1842952formlessly
fortress1136752fortress
furless103210142fur_less
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
effortless1641483effortless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fangless1237663fangless
farles96025783far_le_s
farmers124315263farm_ers
farness102912203far_ness
fartleks1533963fartleks
fatless103212203f_atless
fearless1137873fearless
feckless17225783feckless
feeless103511103f_eeless
feetless1137383feetless
ferules103112723ferule_s
finless102810783f_inless
firmers124711443firm_ers
firmest1239273firm_est
fishless1436413fishless
flagless1235403flagless
flameless1435353flameless
flapless1335343flapless
flawless1434503flawless
flockless1843163flockless
floorless1243793floorless
flourless1243533flourless
flyless1335003f_lyless
foamers123812103foam_ers
foamiest13289853foamiest
foaminess1437503foaminess
focusless1452263focusless
foibles1238853foible_s
foleys123810463fo__leys
folles93820473fo_lle_s
fondlers12338023fondlers
fondles113512613fondle_s
fondness1237213fondness
footlers113910793footlers
footles103715713footle_s
foozlers20346073foozlers
foozles19329543foozle_s
foragers12349633foragers
forages114217283forage_s
foramens1337823foramens
forayers14277273forayers
forceps14466983for_ceps
forcers124215713for_cers
forces114422133for_ce_s
fordoes11311963fordoe_s
foreleg1137743forele_g
fores85847103for__e_s
foresees11311643foresees
forest94926743for__est
forests104114953for__ests
forevers1438173forevers
forgers115218183for_gers
forges105024263for_ge_s
forgets113813793for_gets
forgoers1236413forgoers
forgoes11311353forgoe_s
forkers144615783for_kers
forkiest153812303forkiest
forkiness16268703forkiness
formalins1447213formalins
formalise14239783formalise
formalises15258993formalises
formalism16218183formalism
formalisms17227243formalisms
formalist141910643formalist
formalists15217623formalists
formals123312893form_als
formants13269953formants
formates132814293formates
formats123113573form_ats
forme105225993form_e__
formed125021173form_e_d
formee113919943form_e_e
former114221403form_e_r
formicas1546003formicas
formols12299413form_ols
forms105327053form___s
formulas1346303formulas
formulism16214423formulism
formulisms17254303formulisms
formulist14205913formulist
formulists15204703formulists
formyls15235703form_yls
fortes95327183for_te_s
forties104323863fortie_s
foulest10313313fo_ulest
foulness11236653foulness
fowlers133411203fo_wlers
foxiness18257403foxiness
foziness20257803foziness
frameless1435533frameless
fretless1138063fretless
frockless1843453frockless
froglets1235263froglets
frontless1235403frontless
frostless1235743frostless
fumeless13236603fumeless
furlers104214223fur_lers
fuseless11237233fuseless
garbless11388253garbless
goalless935723goalless
godless938403go_dless
goriness9310753goriness
gumless10228273_gumless
helmless1334273helmless
herbless1336663herbless
holeless1189363holeless
homeless131110143homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
horseless1237223horseless
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
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 9 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.453394461.4
2DLD Change Limit1461622657.95318378.2
3Display Results2652650.1102409.1
 (SQL Overall)1786912658.51620983.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.