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

131 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
leches11542131(None) 
eches106322161_eches
fleches153411441fleches
laches116528351laches
leaches123319341leaches
leched123716001leched
lecher113415851lecher
lechers123313961lechers
lechwes1535061lechwes
leeches123911931leeches
letches124015481letches
lethes94818081lethes
liches114724291liches
lyches144213611lyches
aches106132292_aches
arches114822042arches
baches135426942baches
beaches144120652beaches
beeches143413882beeches
belches143514342belches
benches143918602benches
bleaches153410672bleaches
blenches153310762blenches
boches134618522boches
caches137926912caches
caleches15269942caleches
clenches152910952clenches
cliches144213742cliches
cloches144113712cloches
creches14313092creches
eche97520282_eche_
eched116919222_eched
echoes114715522_echoes
echos105216462_echos
etches114217762etches
feces105625362fec_es
fetches153413892fetches
fiches145219532fiches
fleche14299302fleche_
fleeches16287082fleeches
flenches163410532flenches
fleshes133913272fleshes
fletches16308852fletches
inches114419672inches
itches114916212itches
kenches163912272kenches
ketches164012192ketches
laces76141762lac_es
larches124416452larches
lashes94831002lashes
latches123320132latches
lathes95127502lathes
leached133715042leached
leacher124014842leacher
leachers133712812leachers
leases65428112leases
leashes103514402leashes
leaves94222382leaves
lech96825442lech__
lechery15257642lechery
lechwe1435112lechwe
ledges84918012ledges
leeched13369502leeched
lees45455882le__es
leges64427292le_ges
lehrs86111132le_hrs
lenes54738522le_nes
lenses64620892lenses
leones64417722leones
leses54930812le_ses
letched133912052letched
lethe85717302lethe_
leudes75314092leudes
levees93714522levees
levies93919862levies
lexes127225262le_xes
lezzes14387832lezzes
lichee114017972lichee
lichees123512782lichees
lichen114012742lichen
lichens123510682lichens
lichis115212592lichis
lichts113712382lichts
loaches123613982loaches
lochs106715512loch_s
locoes85516582locoes
luces75528432luc_es
lucres84513302lucres
lunches124115442lunches
lurches123311662lurches
lushes94022742lushes
lycees11428862lycees
lychee143710892lychee
lychees15516782lychees
lynches15378872lynches
maches134827232maches
merches144013762merches
meshes115019442meshes
miches134320732miches
muches134718992muches
naches114622412naches
niches114419142niches
ouches114322182ouches
peaches144120052peaches
peched144915342peched
pechs125516202pech_s
perches143717952perches
pleaches153210432pleaches
plenches153110622plenches
reaches123423202reaches
recces10614912recces
rechew14310212rechew
rechews1537292rechews
reshes94124362reshes
retches123318512retches
riches115022082riches
ruches114819582ruches
seiches12513812seiches
taches114224172taches
teaches122718352teaches
teched124014432teched
techies12513602techies
techs106915832tech_s
tenches123515522tenches
vetches153411262vetches
wechts1446252wechts
welches153710312welches
wenches152914132wenches
wiches144418752wiches
wyches17387912wyches
yechs136112582yech_s

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 Filter178691825510.343520965.0
2DLD Change Limit825511312.37334787.6
3Display Results1311310.0333969.7
 (SQL Overall)1786911312.74965002.2
 
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.