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

121 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
total5532182(None) 
dotal64919621dotal
notal55221351notal
tonal53724301tonal
totals63115161totals
aortal65217512aortal
artal55525472artal
atonal6514022atonal
boral75831702boral
bota66236502bota_
botas75328782botas
botel75121862botel
coal66939252co_al
coital84117052coital
comal95125132comal
copal95621782copal
coral76033452coral
costal85419512costal
cotan71521782cotan
coxal146116672coxal
domal85619202domal
fatal84819372fatal
fetal85623372fetal
foal76630922fo_al
focal104917672focal
foetal9311882foetal
fontal9313142fontal
goal55829302go_al
goral65125752goral
horal86328682horal
hotel85520752hotel
iota45127832iota_
iotas54821112iotas
jota116423622jota_
jotas125717442jotas
joual12311652joual
local74820272local
loral55927822loral
lota47233502lota_
lotah85315852lotah
lotas55926302lotas
loyal84513482loyal
metal75427382metal
modal85919242modal
molal75120342molal
moral75533432moral
mortal84616852mortal
motel76623242motel
natal53921492natal
nodal64717792nodal
nopal75517102nopal
nota46830772nota_
octal71214722octal
opal66923522_opal
oral47638122_oral
ottar54313992ottar
oval77119522_oval
petal76526892petal
portal84218462portal
postal84317532postal
ratal55025112ratal
retotal739842retotal
rota45834342rota_
rotas54827722rotas
rotl45029682rot_l
royal85014702royal
setal56430902setal
sotol54917652sotol
statal61613222statal
stomal85213312stomal
tamal73522622tamal
tatar56122062tatar
teal45546502t_eal
tectal83713252tectal
tepal76319582tepal
tical76021492tical
tidal64516442tidal
titan53318172titan
toad55830182to_ad
today96416952today
toea46732332toea_
toeas55726422toeas
toga57027412toga_
togae67020112togae
togas67823002togas
toil46536282to_il
tokay125513052tokay
tola45236332tola_
tolan55124012tolan
tolar55524112tolar
tolas54532772tolas
toll45535262to_ll
tolyl84710092tolyl
toman75724052toman
tombal102311022tombal
tool46735682to_ol
topaz16315322topaz
tora47545992tora_
torah87125272torah
toras55540372toras
torta55925352torta_
tortas64918252tortas
tot38884772tot__
totable92313362totable
totaled839692totaled
totally1039892totally
tote46643672tot_e
toted64929482toted
totem74819372totem
toter55932132toter
totes55139682totes
tots46654122tot_s
towel84920522towel
trial54926352trial
trotyl9236672trotyl
tubal75517202tubal
typal105311152typal
vital84819672vital
vocal104715642vocal
zoeal144813782zoeal
zonal145116852zonal

Search took 2 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.313570897.8
2DLD Change Limit538001211.57634137.1
3Display Results1211210.0304033.3
 (SQL Overall)1786911211.91993116.7
 
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.