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

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
twat7583151(None) 
swat77244441swat
tat37690291t_at
teat45963631teat
that75639321that
twa67721641twa_
twae74719571twae
twas76824081twas
twats86616601twats
twit76329061twit
wat67378921_wat
at212393402__at
awa611939672awa_
await85524492await
away108024222away
bat510988952_bat
beat66168302beat
blat66550952blat
boat66360312boat
brat66055542brat
cat58282342_cat
chat95546132chat
coat67558342coat
dawt85435942dawt
doat56947672doat
drat56247832drat
eat36989052_eat
fat68178082_fat
feat76458222feat
fiat76646642fiat
flat77147822flat
frat75648542frat
gat46880512_gat
ghat86435282ghat
gnat56034432gnat
goat56250832goat
grat55651282grat
hat67289962_hat
heat77061422heat
hwan105716892hwan
ikat87626642ikat
kat77468292_kat
khat116730722khat
kyat116025522kyat
lat37593402_lat
mat58083932_mat
meat66359602meat
moat66352032moat
neat46356782neat
oat39888262_oat
pat58089462_pat
peat65967932peat
phat95837862phat
plat66048872plat
prat65952042prat
qat125253332_qat
rat37892742_rat
sat36288482_sat
scat65848372scat
seat47575562seat
shat76456592shat
skat87037892skat
slat46959022slat
spat66548522spat
stat47352692stat
stoat57135952stoat
swab96825312swab
swag87526732swag
swam96329982swam
swan76631312swan
swap95925432swap
swart86234642swart
swath115920382swath
swats85726862swats
sway107128232sway
sweat85628402sweat
swot75134652swot
ta211662452t_a_
tab57460322t_ab
tact67349032tact
tad47959822t_ad
tae38267052t_ae
tag47259492t_ag
taj106442192t_aj
tam58663422t_am
tan37167562t_an
tao38358952t_ao
tap57663872t_ap
tar37570692t_ar
tart47566182tart
tas38477102t_as
tate44748602t_ate
tats46858132t_ats
tau36856902t_au
taut47048962taut
tav66043212t_av
taw610155452t_aw
taws75641592taws
tax109449152t_ax
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teats55636812teats
tent46159862tent
test48651622test
tet39274982t_et
text116033932text
thae76825562thae
than76128772than
thaw107521312thaw
thwart12311682thwart
tilt46252422tilt
tint46758862tint
tit36771042t_it
toad55830182toad
toast55831012toast
toft77441652toft
toit46353062toit
toot45958882toot
tort46967462tort
tost48351922tost
tot38884772t_ot
tout46753822tout
tract75635712tract
trad55630912trad
trait56940842trait
tram67034552tram
trap67532802trap
trapt76433392trapt
tray77632592tray
treat56240352treat
tret46653532tret
trot46351312trot
tsar47819802tsar
tuft76929512tuft
tut36758092t_ut
twaes86513662twaes
twain86313622twain
twang94511852twang
tweak1257752tweak
twee76827082twee
tweet84823982tweet
twig87615772twig
twin76023082twin
twist86820982twist
twits86015792twits
twixt155512482twixt
two67925832tw_o
twos76718022twos
tzar136315372tzar
vat67863452_vat
wab87051832_wab
wad77053892_wad
wae67556952_wae
waft106139002_waft
wag76451752_wag
wait75553692_wait
wan66761932_wan
want76156162_want
wap86553372_wap
war67262422_war
wart77866082_wart
was68767562_was
wast75655852_wast
wats77555882_wats
watt75545412_watt
waw97046382_waw
wax137041182_wax
way96757662_way
wet65966622_wet
what105434072what
wit66563772_wit
wot610467482_wot

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.186960704.3
2DLD Change Limit298721761.31322751.0
3Display Results1761760.0602933.3
 (SQL Overall)1786911761.559114619.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.