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

242 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
terns5522687(None) 
erns45428231_erns
ferns85220081ferns
herns84825581herns
kerns94719561kerns
sterns64616761sterns
tarns56433951tarns
teens56227481teens
tens45647411te_ns
terms75523471terms
tern46134801tern_
terne56426151terne
ternes65422901ternes
turns55623241turns
aeons57624652aeons
airns55521032airns
barns76335142barns
beans75734692beans
bens65945702be_ns
bergs84718042bergs
berks115423122berks
berms95323662berms
brens75823362brens
burns74926782burns
carns75937562carns
ceres75540012ceres
ceros74726072ceros
corns76034762corns
curns74924282curns
darns66927892darns
deans66131392deans
dens55945072de_ns
derms85022892derms
durns64819872durns
earns55927562earns
ens37245922_e_ns
eons46638712_eons
eras45441502_eras
ergs55523812_ergs
ern35738362_ern_
erne46727432_erne
ernes55224812_ernes
eros45238452_eros
errs45622532_errs
ers36046282_er_s
eterne6311722eterne
externs1438232externs
fens76139762fe_ns
feres86038182feres
fern76129322fern_
ferny115816182ferny
firns86018542firns
gens55740072ge_ns
germs85118872germs
girns64516802girns
hens75642572he_ns
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herms105626432herms
hern76134892hern_
herons94820542herons
heros84930862heros
hers75844872her_s
horns86125332horns
interns73116772interns
jeans126022112jeans
jerks166514892jerks
karns96624142karns
keens95721182keens
kens85435232ke_ns
kerbs115013672kerbs
kerfs125413572kerfs
kern85326212kern_
kerne94718222kerne
kernes104717532kernes
kirns95315452kirns
leans55536252leans
learns65513742learns
lens46146492le_ns
means75831232means
mercs96020452mercs
meres75143572meres
merks114722402merks
merls77423902merls
morns75527442morns
neons55818682neons
nerds65719252nerds
nerts55924982nerts
peans75437642peans
peens76428192peens
peins76128062peins
pens65649642pe_ns
peons75327182peons
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pirns76020092pirns
porns75527342porns
pterins9812992pterins
querns15307942querns
reins56234562reins
reruns66413742reruns
seres55448892seres
serfs84922012serfs
serins64029672serins
sers45746652ser_s
sorns55028422sorns
steins64818342steins
steres63929532steres
stern55319122stern_
sterna63712762sterna
tains54936322tains
tans46154822t_ans
tares57456562tares
tarn46842722tarn_
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
taverns10317802taverns
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492te_as
teats55636812teats
techs106915832techs
teds54932572te_ds
teels55726372teels
teems76019782teems
teen45938202teen_
teensy9478272teensy
teeny85417882teeny
tees45353582te_es
teffs115111732teffs
teggs74710742teggs
tegs56031492te_gs
teind6213612teind
teinds738262teinds
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692te_ls
temps95417132temps
ten35856112te_n_
tend56433772te_nd
tends65425582tends
tennis64015302tennis
tenons62916602tenons
tense55225842te_nse
tent46159862te_nt
tents56434212tents
tepas76521682tepas
terai53525482terai
terais64023512terais
terce75721842terce
terces83921412terces
terga63315642terga
term66233152ter_m
terra54419662terra
terras63516972terras
terry84721872terry
terse55026822terse
tests56530192tests
teths85418512teths
tetras63017622tetras
tetris62816292tetris
tets45847462te_ts
tews76431642te_ws
texas126514932texas
texts125515042texts
thegns10547432thegns
theins95015422theins
thens85921832thens
theres96525472theres
therms115914872therms
thins85826332thins
thorns95314102thorns
tiers55526522tier_s
tins45251302t_ins
tires55437492tires
tirls54519802tirls
tiros54524892tiros
tons46553052t_ons
toons55027532toons
toras55540372toras
torcs75123762torcs
tores55352672tores
torn46044252torn_
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
towns86018882towns
trans54933042trans
treens65317872treens
trees55835762trees
treks96016852treks
trend64817452trend
trends75513542trends
tres46542902t_res
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
tuns45138662t_uns
turds65021692turds
turfs84620442turfs
turks95320822turks
turn46330392turn_
turps74918732turps
tweens9489842tweens
twerps11345152twerps
twins85118982twins
tyers86220052tyer_s
tyres84725232tyres
tyros85118592tyros
urns46323902_urns
uterus639202uterus
veins84620492veins
verbs104614392verbs
verts85724732verts
warns87231002warns
weans85326742weans
weens85224052weens
wens76337932we_ns
wrens85016242wrens
xerus12313332xerus
yarns85621792yarns
yeans86624882yeans
yearns9509542yearns
yens75832262ye_ns
yerks125416562yerks
zeins144715392zeins
zerks185113822zerks
zeros144918112zeros

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit538002421.89028465.6
3Display Results2422420.0633841.3
 (SQL Overall)1786912422.28378270.3
 
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.