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

144 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
auto4743208(None) 
alto47831261alto
autos56523321autos
abo59045962a_bo
abut66834952abut_
abuts75417072abuts
act59557842act_
acta69524802acta
actor71116072actor
acts66929862acts
acute74720362acute
ado49146872a_do
aero45435342aero
aft66849012aft_
agio57828452agio
ago48845522a_go
ait38093902ait_
aits46355532aits
also46423442also
alt36467962alt_
altho86312602altho
altos55822952altos
alts46639902alts
ambo88225132ambo
ammo85520132ammo
ant37270782ant_
anta46839582anta
ante46538902ante
anti45536362anti
ants47243472ants
apo511142122a_po
apt57352542apt_
arco68331542arco
art38679142art_
arts49650262arts
arty77531312arty
arvo76023432arvo
at212393402a_t_
ate37059242a_te
atom67824522a_tom
atop66124752a_top
att35454652a_tt
audio62917102audio
auk76234142au_k
auks85525262auks
auld54125362auld
aunt46553652aunt
aunts55227632aunts
aunty85919812aunty
aura45836252aura
author939762author
autoed7712822autoed
avo68936232a_vo
azo128233392a_zo
bubo85621902bubo
but55963022but_
bute66739672bute
buteo75419892buteo
buts67247692buts
butt65143742butt
canto74931012canto
cut57957662cut_
cute66440452cute
cuts65841152cuts
dato56129942dato
datto65416422datto
daut56443562daut_
dauts67822242dauts
duo48536142du_o
duro56228022duro
duty85321452duty
euro45325272euro
futon83113772futon
futz167823802futz
gusto65414642gusto
gut46753852gut_
guts56637252guts
haut75949732haut_
haute89521612haute
hut66457292hut_
huts76737442huts
into45026152into
jato115822682jato
juco134716202juco
judo125315302judo
junto125114562junto
jut105944012jut_
jute115327892jute
juts115930162juts
keto86223452keto
koto86323462koto
kudo96115102kudo
lute46341012lute
lutz136826322lutz
maut65448442maut_
mauts75927192mauts
mut58357182mut_
mute65136872mute
muton73817002muton
muts64839982muts
mutt65739402mutt
nut36651962nut_
nuts45032672nuts
onto46127662onto
otto45220642otto
out38072152out_
outdo6312702outdo
outgo6312092outgo
outs45746962outs
ouzo133516932ouzo
panto76129412panto
punto75121322punto
put55759072put_
puton73617912puton
puts65641752puts
putt66937842putt
putto75617662putto
putz158326322putz
rato45436972rato
roto45935052roto
rut35560522rut_
ruth76825992ruth
ruts44541492ruts
santo56227282santo
saute55028082saute
sumo67326312sumo
tanto55724942tanto
taut47048962taut_
tautog765712tautog
tauts56125512tauts
to218858982__to
tut36758092tut_
tutor5712492tutor
tuts45838452tuts
tutu48423172tutu
udo49027302_udo
unto45824282unto
upo58925862_upo
ut28647032_ut_
uta37425582_uta
ute35335882_ute
uts35534372_uts
veto76622992veto
yutz167519882yutz

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 Filter178691298720.0632836365.1
2DLD Change Limit298721440.92032469.6
3Display Results1441440.0304800.0
 (SQL Overall)1786911441.013176397.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.