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

204 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
thy9702291(None) 
shy96728191shy
the67436051the
they107223751they
tho67433961tho
toy69655191toy
try66529671try
why126920011why
aby810238062aby
achy126316092achy
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
any68440482any
ashy107717352ashy
ay511773892_ay
bay89661642bay
bey86645422bey
bothy136713962bothy
boy87753562boy
buy86436542buy
by77529232_by
cay87155982cay
chay124924872chay
chi86228652chi
coy810557552coy
cry89726242cry
day76254112day
dey77243372dey
dry76526032dry
eh58339962eh_
eth66630982eth_
eths76619522eths
ethyl1136512ethyl
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fry96226502fry
gay76856492gay
gey75738302gey
ghi77019882ghi
goy77844552goy
guy75728942guy
ha510259942_ha
hay97358772hay
he58151952_he
hey96741062hey
hi57947582_hi
hm78126732_hm
ho510258272_ho
hoy97447912hoy
hyp117822462_hyp
icy86322122icy
itchy13449012itchy
ivy96317442ivy
jay136242672jay
joy137036362joy
kay106745542kay
key105833332key
khi106318302khi
lathy115215062lathy
lay68865352lay
ley66246812ley
may88757622may
mho86624622mho
mothy136214552mothy
my78125652_my
mythy16568672mythy
nay66952772nay
nth66320592nth_
oh57447002oh_
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oxy136320982oxy
oy58950132_oy
pay88461182pay
phi86524202phi
pht86030522pht
pithy135614462pithy
ply86323552ply
pry85728052pry
ray66361992ray
rho65924832rho
say67264762say
sh56828522sh_
sha69837782sha
shay107133342shay
she66837692she
shh97121072shh
sky106420992sky
sly66228562sly
soy67851452soy
spy86023742spy
stay78333722stay
stey76224412stey
sty66227312sty
ta211662452t_a
tab57460322tab
tad47959822tad
tae38267052tae
tag47259492tag
tahr75217152tahr
taj106442192taj
tam58663422tam
tan37167562tan
tao38358952tao
tap57663872tap
tar37570692tar
tas38477102tas
tat37690292tat
tau36856902tau
tav66043212tav
taw610155452taw
tax109449152tax
tea37353322tea
techy135612012techy
ted46446562ted
tee38366872tee
teg45741622teg
tel35647902tel
ten35856112ten
tet39274982tet
tew66640152tew
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
thee78039062thee
them97427042them
then78429692then
thew108226232thew
thewy146311852thewy
thin76732382thin
thio77225412thio
thir76420542thir
this76027382this
thou76722212thou
thro77726422thro
thru76818942thru
thud85613912thud
thug86415482thug
thus76721472thus
thuya1135582thuya
thyme134612472thyme
thymi13418622thymi
thymy16437922thymy
ti28448292t_i
tic56343462tic
tidy86822412tidy
tie36557532tie
til36350262til
tin36362172tin
tiny76134632tiny
tip56551222tip
tis37056642tis
tit36771042tit
tivy1014516862tivy
to218858982t_o
toby96322292toby
tod49457072tod
tody86327212tody
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
tony75635152tony
too38965422too
top510560682top
tor39261682tor
tory75840542tory
tot38884772tot
tow610557362tow
towy105325472towy
toyo76925452toyo
toys78036342toys
tray77632592tray
trey77228792trey
troy77429682troy
tsk75814732tsk
tub55640032tub
tug45937402tug
tui37034022tui
tun35845192tun
tup56037542tup
tushy114212992tushy
tut36758092tut
tux105426572tux
twa67721642twa
two67925832two
tye65837442tye
typy126013042typy
uh57429852uh_
way96757662way
wha96422072wha
whey135018712whey
who95526772who
whys137011662whys
withy144813762withy
wry96524702wry
yay96948712yay

Search took 1 second 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 Filter178691140840.1101624463.6
2DLD Change Limit140842040.75018778.7
3Display Results2042040.0633238.1
 (SQL Overall)1786912040.923193598.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.