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 “speeches” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

180 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
speeches153741(None) 
beeches143413882_beeches
breeches15258672breeches
fleeches16287082fleeches
leeches123911932_leeches
peaches144120052_peaches
perches143717952_perches
screeches1695652screeches
seethes103613742s_eethes
seiches12513812s_eiches
sketches1746822sketches
sneeshes1136512sneeshes
species11314132sp_ecies
speech1347562speech__
speechless1742322speechless
spences113413922spenc_es
stenches132110292stenches
apaches143411843ap_aches
beaches144120653_beaches
beechen14367703_beechen
belches143514343_belches
benches143918603_benches
beseeches1643953beseeches
bleaches153410673bleaches
blenches153310763blenches
bobeches1744483bobeches
breaches153714123breaches
breeched16337383breeched
caleches15269943caleches
clenches152910953clenches
creches14313093_creches
creeshes1336953creeshes
drenches14309803drenches
eches106322163___eches
etches114217763__etches
fetches153413893_fetches
fleches153411443_fleches
fleeces12399643fleec_es
fleeched17345823fleeched
flenches163410533flenches
fletches16308853fletches
frenches163311633frenches
impeaches1843873impeaches
kenches163912273_kenches
ketches164012193_ketches
kvetches2053583kvetches
leaches123319343_leaches
leches115421313__leches
leeched13369503_leeched
letches124015483_letches
merches144013763_merches
parches143720003_parches
patches143320383_patches
peaces106324083_peac_es
peached154315883_peached
peacher144216073_peacher
peachers153213843_peachers
peched144915343_p_eched
pechs125516203_p_ech_s
peeries93623023_peeries
peeves113814873_pee_ves
peewees1236803_peewees
penoches1538933_penoches
penuches1536943_penuches
perched154713243_perched
percher143313423_percher
perchers153611523_perchers
pieces104217273_piec_es
pinches144117933_pinches
pitches143617753_pitches
pleaches153210433pleaches
plenches153110623plenches
poaches144416943_poaches
pooches143214163_pooches
porches143815673_porches
pouches144116743_pouches
preaches153214893preaches
psyches1755803_psyches
punches144816133_punches
quenches2236013quenches
reaches123423203_reaches
reechoes1338413_reechoes
retches123318513_retches
samechs14285353samech_s
scooches15188413scooches
scorches15189153scorches
scotches15179473scotches
screeched17114343screeched
screecher16144483screecher
screechers17143683screechers
sculches15176273sculches
scutches15168883scutches
searches132112903searches
secedes103711983s_ecedes
seethe93712483s_eethe_
seethed113410193s_eethed
seiche11811833s_eiche_
seviches1635803seviches
sheathes14610193sheathes
sheenies111411543sheenies
sheeves133911953shee_ves
sheuchs15234933sheuch_s
sketched1835393sketched
sketcher1735433sketcher
sketchers1834513sketchers
slatches131511533slatches
sleeves103311343slee_ves
slouches13208073slouches
smirches1535993smirches
smooches15217263smooches
smutches15177273smutches
snatches131410713snatches
sneezes16278503snee_zes
snitches13148983snitches
soroches1338803soroches
spaces104722633sp_ac_es
spathes125116533sp_athes
specced14266703sp_ecced
specie10412223sp_ecie_
specked16329013sp_ecked
speckles16268133speckles
specks144312703sp_ec_ks
specs96916673sp_ec__s
specter113111733sp_ecter
specters122811063sp_ecters
spectres12268683spectres
speechifies2152203speechifies
speechify2251933speechify
speeded113310423spee_ded
speeder103811073spee_der
speeders11339313speeders
speedier1146623speedier
speediest1257473speediest
speedos10298263spee_dos
speeds94316053spee__ds
speedups1342233speedups
speeled103712453spee_led
speels85116393spee__ls
speered103614813spee_red
speers85019953spee__rs
speises93813933sp_eises
speisses10245693speisses
speltzes1944003speltzes
spence103813793spenc_e_
spencer113610973spenc_er
spencers12269193spencers
spenses92913573sp_enses
sphenes123013163sphe_nes
spheres123114353sphe_res
spices104326033sp_ic_es
spinaches1645273spinaches
splashes1337503splashes
splices113914383splic_es
sploshes1336133sploshes
splotches1643913splotches
sprees85620643spre__es
spruces113810503spruc_es
squelches2343363squelches
stanches132312793stanches
starches131912913starches
steelies8312553steelies
steeples1038013steeples
steeves103410903stee_ves
stitches131410593stitches
stretches1438293stretches
subechoes1644563subechoes
swatches16169963swatches
sweenies11148763sweenies
sweeties11159723sweeties
switches16159133switches
teaches122718353_teaches
teethes103611653_teethes
tenches123515523_tenches
trenches133512603trenches
upreaches1654633upreaches
vetches153411263_vetches
welches153710313_welches
wenches152914133_wenches
wrenches163210233wrenches
wretches16257283wretches

Search took 9 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621808.04618165.8
3Display Results1801800.0632857.1
 (SQL Overall)1786911808.56220870.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.