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

127 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
odorless93417(None) 
doorless936711doorless
colorless1145682colorless
motorless1145722motorless
oarless73913372o_arless
orderless1044312orderless
address956103addr_ess
adorers84411733ador_ers
adores74420723ador_e_s
adorners9196623adorners
airless73712043_airless
armorless1143483armorless
barless94317003_barless
blotless10347153blotless
bodiless1135913bod_iless
boonless10328353boonless
bootless103410983bootless
bowless123310313_bowless
browless1346653browless
carless95118493_carless
codeless112010113cod_eless
cookless14258633cookless
cordless11299963_cordless
coreless103013833_coreless
coverless1436803coverless
coxless1637743_coxless
cropless1237793cropless
dewless1137473_dewless
doctorless1342583doctorless
doglegs1034783_doglegs
doles67843753_do_le_s
doodlers10338843doodlers
doodles93614163doodle_s
doolees83711613_doolees
dories75232363_dorie_s
dormers104313923_dormers
dorpers104113173_dorpers
dorsels84412583_dorsels
dorsers83516303_dorsers
dourness947683dourness
dowerless1344013dowerless
downless1236363downless
doyleys14384923_doyleys
dress65319833_d_r_ess
duress74712063_dur_ess
earless74316073_earless
edgeless1034883edgeless
egoless836983ego_less
errorless942813errorless
fearless1137873fearless
floorless1243793floorless
flourless1243533flourless
fogless1138193_fogless
foodless12338383foodless
footless113710803footless
fordless12289003_fordless
forkless15267433_forkless
formless13248083_formless
furless103210143_furless
gearless937373gearless
godless938403_godless
gormless11235443_gormless
hairless1157413hairless
heirless1146053heirless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hornless1137363_hornless
humorless1442963humorless
idealess935653idealess
jobless16237563_jobless
joyless17226513_joyless
knotless1264573knotless
lordless9277483_lordless
moonless10278043moonless
normless10235923_normless
oboles83815833obo_le_s
oddness935313od_dness
odorants946043odorants
odored8399223odor_e_d
odorizes1837213odorizes
odorous837663odor_ous
odors64514283odor___s
odyles10348563od_yle_s
ogress7529503o_gr_ess
oodles73517183o_odle_s
oppress1135993oppr_ess
orbless937493o_rbless
orles55326213__orle_s
outbless1037963outbless
overlets112312363overlets
peerless1037513peerless
plotless10256793plotless
poorness1036363poorness
portless10310643_portless
powderless1642593powderless
powerless1444293powerless
riderless1044903riderless
rodless8310073_rodless
roofless11316733roofless
rootless83910443rootless
savorless1243213savorless
scarless10189053scarless
scoreless1155603scoreless
shoeless1137803shoeless
shoreless1236633shoreless
smogless1134053smogless
snowless1145633snowless
sodaless936113sod_aless
sonless72612613_sonless
spotless1037043spotless
starless81610843starless
tearless848713tearless
thornless1243633thornless
thowless1434613thowless
toeless72612393_toeless
toolless836343toolless
topless92511123_topless
toyless10268713_toyless
vaporless1443163vaporless
visorless1243143visorless
vowless13246603_vowless
warless104015103_warless
woodless12278453woodless
wordless12258843_wordless
workless15276803_workless

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.453394461.4
2DLD Change Limit1461621277.33019940.2
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.82922824.2
 
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.