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

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

176 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
avatars103644(None) 
avatar937521avatar_
abaters95115202abaters
abators94413092abators
altars64518152a_ltars
attars64515312a_ttars
aviators11169902aviators
tatars64619792_tatars
abacas104414723abaca_s
abakas123911743abaka_s
abasers95311973abasers
abater85518123abater_
abates85825033abat_es
abatis84317933abat_is
abator84512723abator_
abattis9297823abattis
abayas114011703abaya_s
ablators1069883ablators
acetals93411353acetals
actors81016773a_ctors
adapters1136103adapters
adaptors1145263adaptors
aerators8315613aerators
afars85716513__afars
afters94717073a_fters
agamas97413453agama_s
agars66120643__agars
agates76121343agat_es
agitas7310593agita_s
alastors8311223alastors
alates64833973alat_es
albatas938373albata_s
alcazars1942963alcazars
alegars838933alegars
altar55520643a_ltar_
alters64924223a_lters
amateurs1043653amateurs
amatols938183amatols
amatory1238643amatory
anabas8314083anaba_s
anatase738943anatase
anatases839793anatases
anattos7138453anattos
anears63717183a_nears
antas55432033a_nta_s
antiars7314623antiars
aortas65417783aorta_s
appears11308953appears
arrears738843arrears
asanas6514113asana_s
ashlars10297063ashlars
asters65631603a_sters
atabals938413atabals
atamans9710433atamans
ataps76414833__ataps
attar56516693a_ttar_
avails939693ava_ils
avers85127313av__ers
averters11249513averters
avgas96912133av_ga_s
avians93711563av_ians
aviary12338413av_iary
aviates10313063aviat_es
aviator10229663aviator_
avigators13177093avigators
avowals1335013avowals
avowers1336333avowers
awaiters1146643awaiters
balatas9311833balata_s
bazaars18275883baza_ars
bazars174613113_bazars
beaters94925043beaters
boaters93419243boaters
calamars1238133calamars
caters85336503_caters
caveators1497263caveators
caviars1238623cav_iars
cavitary1664963cavitary
chadars1338293chadars
coaters93525793coaters
costars94218013costars
cottars94412243cottars
craters95021893craters
damars93815003_damars
datary10310243_datary
daters74827373_daters
daystars1243903daystars
eaters65535953_eaters
elaters74420193elaters
evaders1136933evaders
flatcars1344623flatcars
fraters103517213fraters
gaters74728643_gaters
gators74115843_gators
gazars164811553_gazars
graters85419743graters
guitars8116863guitars
haars85620473_ha_ars
haters94930403_haters
heaters104225223heaters
instars7411133instars
jacamars1944003jacamars
kabars124513953_kabars
kantars11310033kantars
katas95922093_kata_s
kraters114212343kraters
lahars94013163_lahars
lavatory1445703lavatory
lazars153812393_lazars
levators11249283levators
maars74621633_ma_ars
makars124612633_makars
malars85020683_malars
maters85032393_maters
mortars93411523mortars
navars92810573_navars
nectars938463nectars
oaters65029793_oaters
orators7313823orators
ottars64112223_ottars
palatals1037773palatals
patamars1246843patamars
paters84935833_paters
platans93413123platans
platers93924093platers
praters94921653praters
qintars16268573qintars
quasars1646903quasars
radars71314673_radars
ratals64219583_ratals
ratans63819373_ratans
ratatats846063ratatats
raters63936583_raters
ravagers1235583ravagers
reatas64021013reata_s
riatas63915093riata_s
satara6315533_satara
sataras7315063_sataras
satays94411683_satays
satyrs937963_satyrs
savates10312953savat_es
scalars93711903scalars
seaters74028943seaters
sitars65417593_sitars
skaters113512963skaters
slaters73123733slaters
stars55836573__stars
staters73922343staters
stators73915583stators
talars66021683_talars
tars46763953___tars
tartars73313403tartars
tatar56122063_tatar_
taters64932203_taters
tuatara745513tuatara
tuataras844863tuataras
uvulars1044413uvulars
vagary1337333_vagary
vairs85019133_va_irs
valors93413773_valors
vapors113812693_vapors
varas86028193_vara_s
vars75742073_v__ars
vats76841743_vat__s
vatus86114643_vat_us
vavasors14153653vavasors
vaward13498723_vaward
vawards14457573_vawards
velars93913723_velars
viators102712023viators
vicars11712263_vicars
vitals94514303_vitals
votary12248333_votary
voters95017443_voters
wataps11248683_wataps
waters95030633_waters

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271765.87322820.9
3Display Results1761760.0632793.7
 (SQL Overall)1786911766.34228175.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.