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

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

67 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
tronas6381690(None) 
trona54118951trona_
trones65629281trones
arenas65021992arenas
aromas81018612aromas
broncs101611152broncs
coronas93916912coronas
crones84729242crones
donas65926472_donas
drones75023432drones
fronds106412342fronds
frons86124042fron_s
fronts94415792fronts
groans74815062groans
irones64724012irones
irons55324132iron_s
krona93611792krona_
monas74732152_monas
nonas55126652_nonas
proas75028802pro_as
prongs94314482prongs
roans54926442_roans
rotas54827722_rotas
thongs104611192thongs
thrones105715842thrones
throngs11508162throngs
toeas55726422t_oeas
togas67823002t_ogas
tolas54532772t_olas
tonal53724302t_onal
tones56048662t_ones
tongas74315522t_ongas
tongs65928462t_ongs
tons46553052t_on_s
tonus56324302t_onus
toons55027532toon_s
toras55540372t_oras
tortas64918252tortas
tranks104017762tranks
tranqs155210312tranqs
trans54933042tran_s
trends75513542trends
trinal6516962trinal
trines64132562trines
troak95213572tro_ak
troaks104410602troaks
trocar848772trocar
trocars959042trocars
trocks123614632trocks
trogs67022602tro_gs
troikas1135032troikas
trois57226092tro_is
trokes104019262trokes
trolls64613942trolls
tromps104911702tromps
trone55131862tron_e
troops85712782troops
tropes84824352tropes
troths95414152troths
trots56629942tro_ts
trouts66116632trouts
troves94719112troves
trows88826182tro_ws
troys86418612tro_ys
trunks10429752trunks
tunas54224122t_unas
wrongs10338932wrongs

Search took 3 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.326548131.9
2DLD Change Limit82551672.23336968.7
3Display Results67670.0164187.5
 (SQL Overall)178691672.57569394.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.