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

141 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
nth6632059(None) 
eth66630981eth
nah69847001nah
noh66640641noh
aah616252962aah
ah513868792_ah
ankh111114412ankh
ant37270792ant_
anta46839582anta
ante46538902ante
anti45536362anti
ants47243472ants
ash67944602ash
at212393402at_
ate37059242ate
att35454652att
bah87755352bah
bath95940082bath
beth96629232beth
both96533432both
dah78148982dah
doth86225712doth
duh77930382duh
eath75735662eath
edh76921562edh
eh58339962_eh
et26964192et_
eta35834192eta
etch95419142etch
eths76619522eths
feh96136092feh
foh98135892foh
goth86825082goth
hah910655222hah
hath105933912hath
heh96039622heh
heth107028022heth
huh96432012huh
ich86227742ich
inch95420822inch
inti46626082inti
into45026152into
it28455682it_
itch95619172itch
its35538832its
kith115826362kith
lath76640382lath
loth76132132loth
math95437452math
meth95827842meth
month104818422month
moth96731332moth
myth126715432myth
na28652482n_a
nab56954922nab
nae35952742nae
nag46450812nag
nam55953392nam
nan37854882nan
nap56753202nap
natch105018222natch
naw66346492naw
nay66952772nay
ne27045102n_e
neath86020282neath
neb57238622neb
nee36657782nee
neg47237342neg
net36670292net
nets45941532nets
nett46643232nett
new66237092new
nib56745192nib
nigh85220662nigh
nil36144192nil
nim57142952nim
ninth8314582ninth
nip56945982nip
nit37065942nit
nite45943582nite
nits45741642nits
nix106932832nix
no29353242n_o
nob58954422nob
nod47549562nod
nog46847312nog
nom510450642nom
noo37154042noo
nor38048822nor
north86018272north
nos38859322nos
nosh76223542nosh
not39474662not
nota46830772nota
notch105613322notch
note46239962note
now65950192now
nu26331952n_u
nub56439142nub
nun35537742nun
nus37939392nus
nut36651962nut
nuts45032672nuts
oath76132152oath
oh57447002_oh
onto46127662onto
ooh67637092ooh
pah88853592pah
path99134912path
peh86740962peh
pht86030522pht
pith95432692pith
poh86740532poh
rah68052402rah
rath76037662rath
ruth76825992ruth
sh56828522_sh
shh97121072shh
sith75435152sith
snath86419802snath
soth75932522soth
sty66227312sty
synth113711822synth
ta211662452_ta
tenth85421832tenth
teth76327892teth
the67436052_the
tho67433962_tho
thy97022912_thy
ti28448292_ti
to218858982_to
ugh76520682ugh
uh57429852_uh
unto45824282unto
ut28647032ut_
uta37425582uta
ute35335882ute
uts35534372uts
with105730472with
yah99046352yah
yeh97135772yeh

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.250714764.0
2DLD Change Limit140841410.37337758.7
3Display Results1411410.0334272.7
 (SQL Overall)1786911410.656272394.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.