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

152 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
tsar4781980(None) 
osar46820951osar
star48037761star
tar37570691t_ar
tear45242881tear
tsars56717111tsars
tzar136315371tzar
afar76720782afar
agar58726412agar
ajar116217702ajar
alar46340072alar
ar211379382__ar
attar56516692attar
bar58070552_bar
bear66844642bear
boar66134292boar
car59165562_car
char95132152char
czar156013132czar
dear55343602dear
ear36867882_ear
escar74011992escar
eskar9457452eskar
far67762602_far
fear75337792fear
fiar76427332fiar
gar47259902_gar
gear55934972gear
gnar56021382gnar
guar56923292guar
haar77323492haar
hear76143882hear
hoar76729162hoar
izar136616012izar
jar107646152_jar
kbar106514652kbar
knar85818722knar
kyar116916842kyar
lar37967532_lar
lear47045952lear
liar47229682liar
maar66025062maar
mar57965952_mar
near45236502near
oar37057952_oar
ottar54313992ottar
par57467022_par
pear69745232pear
rear45644552rear
roar46328572roar
sab56563202_sab
sac57452862_sac
sad47459202_sad
sae38365182_sae
sag46163402_sag
sal36462882_sal
sap56463232_sap
sard55344242_sard
sari45444042_sari
sark84938972_sark
sat36288482_sat
sau36356572_sau
saw68255352_saw
sax107447642_sax
say67264762_say
scar66434202scar
sear47353842sear
ser36752402_ser
sir35746672_sir
soar46838672soar
spar65433302spar
stab67329932stab
stag57332002stag
stair54719942stair
stare54440262stare
stark95425622stark
stars55836572stars
start55642312start
stat47352692stat
staw78627692staw
stay78333722stay
stir45723252stir
ta211662452t_a_
tab57460322t_ab
tad47959822t_ad
tae38267052t_ae
tag47259492t_ag
tahr75217152tahr
taj106442192t_aj
talar56225382talar
tam58663422t_am
tan37167572t_an
tao38358952t_ao
tap57663872t_ap
tare45957622t_are
tarn46842722t_arn
taro46846912t_aro
tarp66936412t_arp
tars46763952t_ars
tart47566182t_art
tas38477102t_as
task85326652task
tass45640572tass
tat37690292t_at
tatar56122062tatar
tau36856902t_au
tav66043212t_av
taw610155452t_aw
tax109449152t_ax
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tears55436462tears
teary85124052teary
teas45851492teas
teat45963632teat
thae76825562thae
than76128772than
tharm105916642tharm
that75639322that
thaw107521312thaw
thir76420542thir
tiara5315912tiara
tier44936142tier
toad55830182toad
tolar55524112tolar
tor39261682t_or
tora47545992tora
torr45630902torr
tour45530382tour
trad55630912trad
tram67034552tram
trap67532802trap
tray77632592tray
tsade64311122tsade
tsadi6379912tsadi
tsk75814732ts_k
tsks86410662tsks
tussar6369542tussar
twa67721642twa_
twae74719572twae
twas76824082twas
twat75831512twat
tyer75323392tyer
tzars144914272tzars
user45023002user
var66148332_var
war67262422_war
wear75836722wear
yar67253832_yar
year76534252year

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.280638182.1
2DLD Change Limit298721520.89033564.0
3Display Results1521520.0334606.1
 (SQL Overall)1786911521.203148537.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.