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 “toothless” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
toothless124468(None) 
bootless103410982boot_less
footless113710802foot_less
mouthless1444712mouthless
rootless83910442root_less
teethless1243702teethless
toolless836342too_lless
toothiest1237522toothiest
tootlers8289502toot_lers
tootles72915602toot_le_s
truthless1244032truthless
worthless1544922worthless
bathless13127383_bathless
blotless10347153blot_less
boltless10338283bolt_less
boonless10328353boo_nless
bootlegs11325873boot_legs
boughless1543873boughless
coatless1039693coat_less
cookless14258633coo_kless
costless10310003cost_less
deathless1335223deathless
depthless1542753depthless
doorless936713doo_rless
faithless1543903faithless
foodless12338383foo_dless
footlers113910793foot_lers
footles103715713foot_le_s
heathless1535593heathless
hoodless12289733hoo_dless
hoofless14258013hoo_fless
hookless151238363hoo_kless
hoopless13279263hoo_pless
knotless1264573knot_less
loathness1244703loathness
loftless1135903loft_less
mirthless1443353mirthless
moonless10278043moo_nless
mootness1036753moot_ness
motorless1145723motorless
nathless11127023_nathless
noteless839403_noteless
outbless1037963_outbless
pathless13138043_pathless
pithless13117023_pithless
plotless10256793plot_less
poetless1038723poet_less
portless10310643port_less
roofless11316733roo_fless
rootiness979063rootiness
rootles73215633root_le_s
rootlets8308653root_lets
ruthless1135413_ruthless
smoothness1543043smoothness
soothers113913433sooth_ers
soothes103917113sooth_e_s
soothest113312243sooth_est
sootiness999833sootiness
spotless1037043spot_less
tactless10288463tact_less
tasteless935673tasteless
tentless8229843tent_less
textless15245793text_less
thornless1243633thornless
thowless1434613tho_wless
tintless8239863tint_less
toadless936313t_oadless
toeless72612393t_o_eless
tombless1236783t_ombless
toneless8610393t_oneless
toolers74416503too__lers
tooters73818773toot__ers
toothed113310243tooth_e_d
toothier1136423toothie_r
toothlike1643723toothlike
tooths96013803tooth___s
tootle62613813toot_le__
tootled83511043toot_le_d
tootler73511123toot_le_r
tootses72910773toot_se_s
tootsies848613tootsie_s
topless92511123t_o_pless
toughness1355093toughness
townless1135653t_ownless
toyless10268713t_o_yless
trochleas1444713trochleas
voteless1137493_voteless
woodless12278453woo_dless

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 Filter1786911486410.830215290.4
2DLD Change Limit148641887.61019532.3
3Display Results88880.0461913.0
 (SQL Overall)178691888.48621057.2
 
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.