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

71 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
tonearms104471(None) 
tonearm937441tonearm_
forearms1336602forearms
toners64128002tone_r_s
anears63717183_anear_s
atoners75013953atone_r_s
boners84825433bone_r_s
boneyards1584623boneyards
confirms1536303confirms
conforms1538873conforms
dogears937513dogear_s
firearms1335403firearms
forearm1238703forearm_
goners74420173gone_r_s
honers94324973hone_r_s
inarms8410093_in_arms
loners64225813lone_r_s
monerans10310343monerans
nears55529423__near_s
nonarts7311303non_arts
nonfarm1246513nonfarm_
nonwars10109003nonwar_s
onwards1137173_onwards
overarms13258383_overarms
poniards1145823poniards
prearms11369173_prearms
rearms85114653__rearms
sidearms1144093sidearms
sonars64818973son_ar_s
stoners74817953stone_r_s
stonewares1344013stonewares
tanbarks1445563tanbarks
tangrams1136163tangrams
tankards1366253tankards
tantaras8269543tantaras
tanyards1276183tanyards
teams75726513t__ea_ms
tears55436463t__ear_s
terms75523473t__e_rms
tharms115712243t__harms
thenars10248523thenar_s
therms115914873t_he_rms
tineas64616483tinea__s
tinwares1137913tinwares
toeas55726423to_ea__s
toenails847213toenails
tokers104818893toke_r_s
tolars64817943to_lar_s
toneless8610393toneless
toneme8312103tone__me
tonemes9311683tone_mes
toner55336243tone_r__
tones56048663tone___s
tonetics1048943tonetics
tonettes839203tonettes
tongas74315523tonga__s
tongers84116013tonger_s
tonnages9187873tonnages
tonneaus853913tonnea_us
tonners73816403tonner_s
tonsures869133tonsures
topers85025323tope_r_s
toreros7311343tore_ros
totems86810763tote__ms
toters65026363tote_r_s
towards1138783to_wards
towers94423673towe_r_s
toyers95516333toye_r_s
tuners64417343tune_r_s
unarms839243_un_arms
zoners155115993zone_r_s

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.423422437.4
2DLD Change Limit146162717.26620115.9
3Display Results71710.0135461.5
 (SQL Overall)178691717.70223200.6
 
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.