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

109 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
techs10691583(None) 
pechs125516201pechs
tachs105820931tachs
tech95925441tech_
techy135612011techy
teths85418511teths
yechs136112581yechs
becks135522012becks
beths105519222beths
decks124822192decks
decos85522122decos
eche97520282_eche
eches106322162_eches
echo96615952_echo
echos105216462_echos
echt95722902_echt
ecus65421462_ecus
edhs86212102_edhs
etch95419142etch_
etches114217762etches
eths76619522_eths
feces105625362feces
fecks145417852fecks
fehs106522382fe_hs
gecks125117092gecks
hecks145220652hecks
hehs106723962he_hs
heths116317782heths
heuchs14447922heuchs
ichs96214712_ichs
kecks105416572kecks
lech96825442lech_
leches115421312leches
lochs106715512lochs
machs125722562machs
meths105320232meths
necks115119332necks
pech116125452pech_
pecks135724432pecks
pecs84634102pec_s
pehs95625762pe_hs
recks115625132recks
recs65734182rec_s
secs65033892sec_s
sects75622892sects
stichs114511652stichs
taces76237802taces
tach96132752tach_
tache106222372tache
taches114224172taches
tacks115430132tacks
tacos77023552tacos
tacts76524122tacts
teach105221122teach_
teaches122718352teaches
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492te_as
teats55636812teats
teched124014432teched
techie11511722techie
techies12513602techies
techno1135952techno
technos1236182technos
tecta74215522tecta
teds54932572te_ds
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582te_es
teffs115111732teffs
teggs74710742teggs
tegs56031492te_gs
telcos8710682telcos
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692te_ls
temps95417132temps
tench105620002tench_
tenches123515522tenches
tends65425582tends
tens45647412te_ns
tenths94412662tenths
tents56434212tents
tepas76521682tepas
terces83921412terces
terms75523472terms
terns55226872terns
tests56530192tests
tetchy1436002tetchy
teth76327892teth_
tets45847462te_ts
teuch105214852teuch_
tews76431642te_ws
texas126514932texas
texts125515042texts
ticks115823292ticks
tics65729632tic_s
tophs105220052tophs
tucks114721122tucks
wecht13415442wecht
wechts1446252wechts
yeahs115214552yeahs
yecchs16414952yecchs
yech127220532yech_
yechy16519082yechy

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.326548131.9
2DLD Change Limit538001091.73331044.4
3Display Results1091090.0333303.0
 (SQL Overall)1786911092.09285416.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.