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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
atones6522577(None) 
agones75719861agones
atone56527981atone_
atoned75417541atoned
atoner64817191atoner
atoners75013961atoners
atonies75320951atonies
axones134614511axones
stones65130031stones
tones56048661_tones
abodes94417512abodes
aboves114512842aboves
acetones10310032acetones
acnes75922622a_cnes
adobes94411532adobes
adonis7314062adonis
adores74420722adores
aeons57624652aeon_s
agenes74720252agenes
agone65924552agone_
agonies83016622agonies
agons66423782agon_s
akenes104817342akenes
alines65735222alines
aloes54933672alo_es
alone55732962alone_
ambones11312682ambones
amines84727982amines
amoles84122192amoles
ancones93116342ancones
anes45255932a__nes
anodes74418762anodes
anoles64827432anoles
arenes64928392arenes
astonies8815112astonies
ates45047922at__es
atolls65511352atolls
atomies93918362atomies
atoms76817562ato_ms
atonal6514022atonal
atonia63816512atonia
atonias73315992atonias
atonic83420472atonic
atonics93613712atonics
atony87218852aton_y
atopies92816432atopies
attunes737822attunes
axone125918472axone_
axons125517932axon_s
azines155517072azines
azoles154614612azoles
azons146518252azon_s
azotes154312222azotes
batons85519422baton_s
bones76446532_bones
cajones163311332cajones
clones84526562clones
cones76457422_cones
crones84729242crones
drones75023432drones
hones88144492_hones
icones84616382icones
intones7816542intones
irones64724012irones
jones125028182_jones
ketones115014502ketones
lactones10311242lactones
leones64417722leones
nones55639132_nones
ones46146532__ones
ozones1539392ozones
patines95225762patines
peones83821042peones
phones114121212phones
pones74547042_pones
ptoses83514672ptoses
ratines75328582ratines
scones84521302scones
sones55444142_sones
stanes64933402stanes
stokes104821792stokes
stoles63927672stoles
stone55431182stone_
stoned75923142stoned
stoner65823202stoner
stoners74817962stoners
stoney96217352stoney
stopes84525892stopes
stores65533662stores
stoves93818922stoves
tines54848422_tines
toes46956442_to_es
tokes95234972_tokes
toles55147132_toles
tomes76037382_tomes
tone46953742_tone_
toned65435342_toned
toner55336242_toner
toners64128002_toners
toney86027412_toney
tongs65928472_tongs
tonnes65320852_tonnes
tons46553052_ton_s
tonus56324302_tonus
topes76941762_topes
tores55352672_tores
totes55139682_totes
trones65629282trones
tunes55332192_tunes
tynes85920302_tynes
zones145528042_zones

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825511112.73630172.1
3Display Results1111110.0303700.0
 (SQL Overall)1786911113.12657162.8
 
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.