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

156 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
tech9592544(None) 
etch95419141etch
lech96825441lech
pech116125451pech
tach96132751tach
teach105221121teach
techs106915831techs
techy135612011techy
tench105620001tench
teth76327881teth
teuch105214851teuch
yech127220531yech
arch98628442arch
bach116131392bach
beach124623892beach
beck126226572beck
beech124315502beech
belch124415502belch
bench125619502bench
beth96629232beth
ceca84820782ceca
deck115827752deck
deco76125972deco
each95530582each
eche97520282_eche
echo96615952_echo
echt95722902_echt
ecu56828232_ecu
edh76921562_edh
eh58339962_e_h
eth66630982_eth
feck134923432feck
feh96136092fe_h
fetch134913472fetch
geck115721992geck
heck135826492heck
heh96039622he_h
heth107028022heth
heuch135312332heuch
ich86227742_ich
inch95420822inch
itch95619172itch
keck94920712keck
kench145513922kench
ketch144912022ketch
leach105422522leach
leech104913212leech
letch105215802letch
lich96230842lich
loch95527132loch
lych126015762lych
mach116134472mach
merch125417962merch
mesh96823002mesh
meth95827842meth
much115224032much
neck105423662neck
ouch95724632ouch
peach125422492peach
pec76744412pec_
pechs125516202pechs
peck125730682peck
pecs84634102pecs
peh86740962pe_h
perch124518832perch
reach105123882reach
rec55645462rec_
reck106130562reck
recs65734182recs
resh76523452resh
retch104818302retch
rich97025542rich
sec55945322sec_
secs65033892secs
sect67443622sect
stench114111162stench
stich104117922stich
such96424812such
tace65342512tace
tache106222372tache
tachs105820932tachs
tack106536292tack
taco67031352taco
tact67349032tact
tea37353322te_a
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
teched124014432teched
techie11511722techie
techno1135952techno
tecta74215522tecta
ted46446562te_d
teds54932572teds
tee38366872te_e
teed55439262teed
teel46335802teel
teem66132602teem
teen45938202teen
tees45353582tees
teeth87315852teeth
teff106023762teff
teg45741622te_g
tegg65315922tegg
tegs56031492tegs
tel35647902te_l
tela45532972tela
telco7511872telco
tele45040872tele
tell44934702tell
tels46841692tels
temp85323332temp
ten35856112te_n
tend56433772tend
tens45647412tens
tent46159862tent
tenth85421832tenth
tepa66021682tepa
terce75721842terce
term66233152term
tern46134802tern
test48651622test
tet39274982te_t
tetchy1436002tetchy
teths85418512teths
tets45847452tets
teugh95511612teugh
tew66640152te_w
tews76431642tews
text116033932text
theca103311452theca
tic56343462tic_
tick106231222tick
tics65729632tics
toph96326872toph
torch107420932torch
tosh74826812tosh
touch106519392touch
trench114211612trench
tuck104626572tuck
tush74523902tush
vetch134411842vetch
wecht13415442wecht
welch134411492welch
wench136214782wench
wich125724742wich
wych154011882wych
yeah106725412yeah
yecch15558092yecch
yechs136112582yechs
yechy16519082yechy
yeh97135772ye_h
yuch125818532yuch

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.0632836365.1
2DLD Change Limit298721561.00029872.0
3Display Results1561560.0463391.3
 (SQL Overall)1786911561.109161128.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.