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

223 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
roofless1131673(None) 
hoofless14258011hoofless
rootless83910441rootless
boonless10328352boonless
bootless103410982bootless
broodless1235032broodless
cookless14258632cookless
doorless936712doorless
foodless12338382foodless
footless113710802footless
hoodless12289732hoodless
hookless151238362hookless
hoopless13279262hoopless
moonless10278042moonless
roadless937702roadless
rockless14297292rockless
rodless8310072r_odless
roofers105013902roof_ers
roofies103014412roofie_s
rootles73215632rootle_s
rootlets8308652rootlets
toolless836342toolless
woodless12278452woodless
aloofness1242493aloofness
armorless1143483armorless
arrowless1242813arrowless
beefless1335493beefless
bloodless1234513bloodless
bloomless1342963bloomless
blotless10347153blotless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boodlers113710743boodlers
boodles103416043boodle_s
booklets14247123booklets
boomlets12246673boomlets
bootlegs11325873bootlegs
bowless123310313_bowless
briefless1443623briefless
brooklets1543683brooklets
browless1346653browless
coalless1038193coalless
coatless1039693coatless
codeless112010113codeless
coffles152610003coffle_s
colorless1145683colorless
confess12399903conf_ess
coolers93522493coo_lers
coolest9318643coo_lest
coolness1037743coolness
cordless11299963cordless
coreless103013833coreless
costless10310003costless
coxless1637743_coxless
cropless1237793cropless
crownless1443423crownless
cuffless1634293cuffless
doodlers10338843doodlers
doodles93614163doodle_s
doofuses1244283doofuses
doolees83711613doo_lees
downless1236363downless
egoless836983ego_less
errorless942813errorless
floorless1243793floorless
foamless13195843foamless
fogless1138193_fogless
footlers113910793footlers
footles103715713footle_s
foozlers20346073foozlers
foozles19329543foozle_s
fordless12289003fordless
forkless15267433forkless
formless13248083formless
frockless1843453frockless
frontless1235403frontless
frostless1235743frostless
goalless935723goalless
godless938403_godless
goodness1036253goodness
goofiest12289393goofiest
goofiness1365603goofiness
gormless11235443gormless
groveless13235363groveless
holeless1189363holeless
homeless131110143homeless
hoofers134513333hoof_ers
hooklets15217203hooklets
hopeless13118303hopeless
hornless1137363hornless
jobless16237563_jobless
joyless17226513_joyless
knotless1264573knotless
leafless11246573leafless
loamless10235213loamless
loftless1135903loftless
lordless9277483lordless
lossless835473lossless
loveless1168573loveless
mooleys1236863moo_leys
moonlets10247473moonlets
mootness1036753mootness
motorless1145723motorless
moveless1367753moveless
noodles83513193noodle_s
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
oarless73913373_oarless
odorless934173odorless
oodles73517183_oodle_s
orbless937493_orbless
plotless10256793plotless
poetless1038723poetless
poleless1089873poleless
poodles103013513poodle_s
poofters1336923poofters
poolers94217423poo_lers
poorness1036363poorness
popeless1288473popeless
portless10310643portless
profess1237713prof_ess
proofers13118363proof_ers
rafflers14317373rafflers
raffles133611853raffle_s
rainless8129713rainless
rankless12268243rankless
rayless10239003r_ayless
reckless14257973reckless
reflets103513153r_eflets
reinless8139443reinless
reoffers1434693reoffers
restless82713163restless
ribless93410343r_ibless
rifflers14336453rifflers
riffles133911173riffle_s
riflers103512203r_iflers
rifles94217713r_ifle_s
riftless1136943riftless
rimless9369363r_imless
rindless92510203rindless
riskless1235763riskless
robles85321693r_oble_s
roles56747983r_o_le_s
rolfers104011813rolf_ers
rollers73117473r_ollers
roofed105214743roof_e_d
roofer94415283roof_e_r
roofie93411173roofie__
roofings12256023roofings
rooflike1534623rooflike
roofline1136193roofline
rooflines1245373rooflines
roofs85321153roof___s
rooftops13152913rooftops
rooftrees1242403rooftrees
rookies113917103rookie_s
rookiest122912173rookiest
roomers95416413roo_mers
roomies93017243roomie_s
roomiest102611993roomiest
roominess1157303roominess
roosers74217883roo_sers
rooses65526243roo_se_s
roosters83514673roosters
rooters74522933roo_ters
rootiest83115593rootiest
rootiness979063rootiness
rootle63214453rootle__
rootled83410533rootle_d
rootlet73015733rootle_t
ropiness102311073ropiness
rosiness82613183rosiness
roubles93413513rouble_s
rufflers14347193rufflers
ruffles133512273ruffle_s
ruleless836633ruleless
rumpless12256543rumpless
rungless956733rungless
runless72810423r_unless
rustless83510243rustless
ruthless1135413ruthless
selfless1135013selfless
shoeless1137803shoeless
smogless1134053smogless
snowless1145633snowless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sonless72612613_sonless
soulless8218763soulless
soupless10268463soupless
spotless1037043spotless
thowless1434613thowless
toadless936313toadless
toeless72612393_toeless
tombless1236783tombless
toneless8610393toneless
toolers74416503too_lers
toothless1244683toothless
tootlers8289503tootlers
tootles72915603tootle_s
topless92511123_topless
townless1135653townless
toyless10268713_toyless
turfless1135533turfless
voteless1137493voteless
vowless13246603_vowless
woofers133810583woof_ers
woolens10398843woo_lens
woolers104214023woo_lers
woollens1144093woollens
wordless12258843wordless
workless15276803workless
yokeless1535303yokeless
zoneless1737823zoneless
zoogleas1843373zoogleas

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.403443402.0
2DLD Change Limit1461622236.54622328.4
3Display Results2232230.0802787.5
 (SQL Overall)1786912237.02925422.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.