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

115 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
yeti7582321(None) 
yet66960691yet_
yetis85418391yetis
yett76434491yett
anti45536362anti
bet58376672bet_
beta66234132beta
beth96629232beth
bets67051442bets
cedi74919272cedi
cesti75217422cesti
cete64934782cete
defi86321492defi
deli55631292deli
deni56929392deni
et26964192_et_
eta35834192_eta
eth66630982_eth
etic66123952_etic
etui45416232_etui
fet66471632fet_
feta76528902feta
fete75734922fete
fetid93715982fetid
fets75345942fets
get47467462get_
geta56627442geta
gets55442482gets
het67674312het_
heth107028022heth
hets75547202hets
inti46626082inti
jet106754822jet_
jete115927252jete
jets115834102jets
kepi105315632kepi
keto86223452keto
lati46438272lati
lei36846382le_i
let36481472let_
lets47147942lets
loti46431842loti
met56072432met_
meta65932412meta
mete64438132mete
meth95827842meth
metis75025902metis
net36670292net_
nets45941532nets
nett46643232nett
nevi75116422nevi
peri65636972peri
pet56477302pet_
petit74332652petit
pets66248332pets
petti75119452petti
recti73619622recti
rei35647252re_i
ret35982832ret_
rete44944132rete
retia55326112retia
retie55735302retie
rets45352562rets
roti46332932roti
sati45539332sati
sei36048932se_i
semi65127222semi
senti56226702senti
set36681252set_
seta45637312seta
sets45549502sets
sett45949052sett
tet39274992tet_
teth76327892teth
tetri52716452tetri
tets45847462tets
ti28448292__ti
titi47130622titi
vet65958522vet_
veto76622992veto
vets76835092vets
wet65966622wet_
wets75940292wets
xysti15538152xysti
yagi86922242yagi
ye57650062ye__
yea66445752ye_a
yeah106725412yeah
yean75834582yean
year76534252year
yeas78638422yeas
yech127220532yech
yegg96511792yegg
yeh97135772ye_h
yeld811423872yeld
yelk115320002yelk
yell76028322yell
yelp95621352yelp
yen66847382ye_n
yens75832262yens
yenta83917042yenta
yente86220042yente
yep86638962ye_p
yeps95924402yeps
yerk116222082yerk
yes66250612ye_s
yetts86715132yetts
yeuk116015472yeuk
yew96436292ye_w
yews105323962yews
yogi86120422yogi
yoni77524392yoni
yutz167519882yutz
zeta135121642zeta
ziti136022372ziti

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.283631417.0
2DLD Change Limit298721150.81036879.0
3Display Results1151150.0333484.8
 (SQL Overall)1786911151.126158695.4
 
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.