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

113 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
torot5613994(None) 
tarot55943931tarot
toot45958881to_ot
toro48045681toro_
toros54336191toros
toroth95512961toroth
tort46967461tor_t
trot46351311t_rot
agorot7415002agorot
boot67759372bo_ot
boron76727142boron
bort65960962bor_t
coot67860382co_ot
foot76248012fo_ot
forgot104318132forgot
fort76456442for_t
grot55942052_grot
hoot75752102ho_ot
horst85833512horst
korat94934432korat
lirot5430032lirot
loot46955822lo_ot
moot67653622mo_ot
moron76925422moron
mort66758832mor_t
oot311274692_o_ot
ort39465232_or_t
port66059632por_t
robot7325972robot
root45655922ro_ot
rot37282952__rot
soot45761062so_ot
sort46264812sor_t
taro46846912taro_
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarots66422992tarots
tart47566182tar_t
thoro86217872thoro_
thoron94713902thoron
thro77726422thro_
throat94819752throat
throb109816852throb
throe89321422throe
throw118719732throw
tiro46832362tiro_
tiros54524892tiros
toast55831012toast
toft77441652to_ft
toit46353062to_it
too38965422to_o_
took86531072to_ok
tool46735682to_ol
toom66532932to_om
toon47740632to_on
tooth88020182to_oth
toots55331872to_ots
topo66932402topo_
topoi76018352topoi
topos75726392topos
tor39261682tor__
tora47545992tor_a
torah87125272torah
toras55540372toras
torc66333352tor_c
torch107420932torch
torcs75123762torcs
tore47359322tor_e
tores55352672tores
tori47542152tor_i
toric76529312toric
torii55521592torii
torn46044252tor_n
toroid7416012toroid
torose64317692torose
torous64319032torous
torpor839192torpor
torr45630902tor_r
torrs53923562torrs
tors46157382tor_s
torse55833332torse
torsi57423362torsi
torsk94915772torsk
torso56922142torso
torsos64815732torsos
torta55925352torta
torte55431702torte
torts56138122torts
torus54329762torus
tory75840542tor_y
tost48351922to_st
tot38884772t__ot
tout46753822to_ut
toyo76925452toyo_
toyon86715672toyon
toyos87519142toyos
tret46653532t_ret
trod57627952t_rod
trog57628212t_rog
troop76417532troop
trooz145016152trooz
trop66833302t_rop
troth85622202t_roth
trots56629942t_rots
trout57332572trout
trow78031422t_row
troy77429682t_roy
turbot8914262turbot
tyro76622362tyro_
tyros85118592tyros
worst86330132worst
wort76654752wor_t

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 Filter178691538000.326548131.9
2DLD Change Limit538001131.64032804.9
3Display Results1131130.0333424.2
 (SQL Overall)1786911131.99989390.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.