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

245 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
avatar93752(None) 
avatars1036441avatars
abater85518122abater
abator84512712abator
altar55520642a_ltar
attar56516692a_ttar
aviator10229662aviator
tatar56122062_tatar
abaca95118043abaca_
abacas104414723abacas
abaka114313823abaka_
abakas123911743abakas
abaser86414343abaser
abate76627843abat_e
abated95918453abated
abaters95115193abaters
abates85825033abates
abatis84317933abatis
abators94413073abators
abaya104413173abaya_
abayas114011703abayas
ablator939843ablator
aceta74017353aceta_
acetal84314903acetal
acinar8310483acinar
acta69524803a_cta_
actor71116073a_ctor
acuter84412863acuter
adapter1036173adapter
adaptor1034943adaptor
adyta936853adyta_
aerator7314843aerator
afar76720783__afar
after85719793a_fter
agama85815573agama_
agamas97413443agamas
agapae9388043agapae
agapai9456843agapai
agar58726413__agar
agate66525143agat_e
agates76121333agates
agita6315423agita_
agitas7310593agitas
ajar116217703__ajar
alar46340073__alar
alastor739653alastor
alate55340323alat_e
alated75625143alated
alates64833963alates
albata839333albata_
albatas938373albatas
alcazar1843453alcazar
alegar739283alegar
altars64518153a_ltars
alter54828503a_lter
alular6311353alular
amateur933883amateur
amatol838683amatol
amatory1238613amatory
anabas8314083anabas
anatase738943anatase
anatto6139913anatto
anear55420323a_near
anta46839583a_nta_
antae56828293a_ntae
antas55432033a_ntas
antiar6317173antiar
antra56521923a_ntra
aorta55922573aorta_
aortae65115473aortae
aortal65217513aortal
aortas65417783aortas
apathy1437033apathy
appear10379343appear
apter76120203a_pter
arrear6310253arrear
artal55525473a_rtal
asana5315483asana_
asanas6514113asanas
ashlar9338193ashlar
aster55434893a_ster
astir55517093a_stir
atabal839743atabal
ataman81013063ataman
atap66722453__atap
attars64515313a_ttars
aurar54420253a_urar
ava610139323av__a_
avail8313883ava_il
avails939693avails
avant86224663ava_nt
avast85519363ava_st
avaunt959603avaunt
aver75931883av__er
averter102410553averter
avgas96912133av_gas
avian84616053av_ian
aviary12338413av_iary
aviate9315203aviat_e
aviated11310263aviated
aviates10313063aviates
aviatic1239243aviatic
aviators11169903aviators
avigator12236763avigator
avowal1246323avowal
avower1236823avower
awaiter1057443awaiter
balata8614673balata_
balatas9311833balatas
bazaar17306403baza_ar
bazar163816003_bazar
beater84729393beater
boater84622093boater
calamar1149293calamar
cater74840703_cater
caveator1387233caveator
caviar11310163cav_iar
cavitary1664963cavitary
chadar1239343chadar
coater84329553coater
costar85518613costar
cottar84613813cottar
crater85026633crater
damar84117733_damar
data56026653_data_
datary10310243_datary
dater65332313_dater
daystar1143443daystar
eater54639843_eater
elater64724203elater
evader1036813evader
fatal84819373_fatal
feater95224053feater
flatcar1274613flatcar
frater94520593frater
gater64533643_gater
gator64416033_gator
gazar154612983_gazar
grater74625433grater
guitar7117443guitar
haar77323493_ha_ar
hater85034753_hater
heater94828303heater
hiatal9310193hiatal
instar6310013instar
irater65218343irater
jacamar1844323jacamar
kabar114815553_kabar
kantar10311153kantar
kata85626023_kata_
katas95922093_katas
krater104014313krater
lahar83114263_lahar
later54843923_later
lavatory1445693lavatory
lazar144113643_lazar
levator10298963levator
maar66025053_ma_ar
makar115614973_makar
malar76424443_malar
mater74438863_mater
meatal84114733meatal
mortar83812043mortar
natal53921493_natal
navar83912733_navar
neater64424313neater
nectar838853nectar
oater55433733_oater
orator6314533orator
ottar54313993_ottar
ovate84214393ovat_e
ovular946833ovular
palatal9310153palatal
patamar1147093patamar
pater74740723_pater
planar84212713planar
plantar9369993plantar
platan83913693platan
plater84427693plater
prater84825353prater
qintar15359143qintar
quasar1536833quasar
radar61316723_radar
ratal55025113_ratal
ratan53722663_ratan
ratatat7412263ratatat
rater54943283_rater
ravager1136553ravager
reata54225393reata_
reatas64021013reatas
riata54618023riata_
riatas63915083riatas
satara6315533_satara
satay84718463_satay
satyr848483_satyr
savager1137133savager
savate9313783savat_e
savates10312953savates
scalar83612433scalar
seater64534153seater
sitar54820543_sitar
skater105015483skater
slater64429183slater
star48037763__star
statal61613223statal
stater64427553stater
stator64015473stator
svaraj1634963svaraj
talar56225383_talar
tar37570693___tar
tartar63214753tartar
tatars64619793_tatars
tater54138613_tater
tuatara745503tuatara
uvular955563uvular
vagal94613633_vagal
vagary1337333_vagary
vair75624143_va_ir
valor83614893_valor
valvar12388653valvar
vapor104013093_vapor
var66148333_v__ar
vara75530883_vara_
varas86028193_varas
vasa76522973_vasa_
vasal85516293_vasal
vaster94521023vaster
vat67863453_vat__
vatic10316423_vatic
vats76841743_vat_s
vatu76524333_vat_u
vatus86114643_vatus
vavasor13143603vavasor
vaward13498723_vaward
velar85817633_velar
viator93211833viator
vicar10513863_vicar
vita75828523_vita_
vitae84217633_vitae
vital84819673_vital
volar86917413_volar
votary12248333_votary
voter85121053_voter
watap102111673_watap
water84733313_water

Search took 8 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162457.65614722.6
3Display Results2452450.0803062.5
 (SQL Overall)1786912457.87622688.0
 
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.