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

286 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
leeching1431837(None) 
fleeching18305011fleeching
leaching143012831leaching
leching134613651l_eching
letching143810261letching
beaching164114142beaching
belching16349152belching
benching163411342benching
bleaching17287092bleaching
blenching17276502blenching
breeching17236472breeching
clenching17266302clenching
eching126315562__eching
electing112113782electing
etching134511842_etching
fetching17298412fetching
fleecing14347572fleec_ing
flenching18296702flenching
fletching18256142fletching
latching143712022latching
leashing123310312leashing
leering83417642lee_ring
lunching143110002lunching
lurching14277332lurching
lynching17336082lynching
peaching163613642peaching
peching154513902_peching
perching163711632perching
pleaching17257082pleaching
reaching143317202reaching
reechoing1545292reechoing
retching143412172retching
seething1239022seething
teaching143612602teaching
teething1237162teething
welching17287362welching
wenching17328862wenching
aching126521973__aching
arching136216693_arching
baching156017753_baching
batching163712093batching
becking164416073_becking
bedecking1934283bedecking
beechen14367703beechen_
beechier1535633beechier
beefing133911473bee_fing
beeping124013913bee_ping
beeswing14255763beeswing
beetling1139283beetling
berthing14209593berthing
beseeching1843363beseeching
birching16328463birching
bitching163610623bitching
blanching17297093blanching
bleeding12359053blee_ding
bleeping13377933blee_ping
blotching1734963blotching
botching16359703botching
breaching17269403breaching
breechings18273723breechings
bunching163410703bunching
caching156317503_caching
catching163712773catching
checking20379203checking
cinching163310223cinching
cleeking15267813clee_king
clinching17276123clinching
clutching17154823clutching
coaching164011963coaching
couching163213263couching
creeshing1536243creeshing
deashing134210953deashing
decking153915593_decking
deeding103315123dee_ding
deeming113913123dee_ming
defecting162510223defecting
deicing11312193deic_ing
dejecting20217793dejecting
detaching1637263detaching
detecting13259983detecting
deucing1139393deuc_ing
ditching15349943ditching
douching15349843douching
drenching16256033drenching
echini114710433__echini
echoing1358613__echoing
ejecting18268163ejecting
erecting112415063erecting
etchings14396293_etchings
euchring1436613_euchring
feeding123515073fee_ding
feeing104416503fee__ing
feeling113617073fee_ling
feezing204610163fee_zing
fencing132411133fenc_ing
filching1736113filching
flecking18408233flecking
fleeing113511293flee__ing
fleering123811283flee_ring
fleeting122910323flee_ting
fleshing15339303fleshing
fletchings19282863fletchings
flinching18245833flinching
flitching18265343flitching
frenching18267753frenching
freshing152611023freshing
gecking154111363_gecking
geeing84313763gee__ing
gleeking14316493glee_king
gleeting10279173glee_ting
glunching16174083glunching
hatching173312213hatching
heeding123515063hee_ding
heeling113618513hee_ling
heezing20349873hee_zing
hitching173310523hitching
hotching17309313hotching
hunching17309113hunching
hutching17318643hutching
inching134414323_inching
itching134011683_itching
jeeing144512143jee__ing
jeeping174010333jee_ping
jeering153513043jee_ring
kecking134111883_kecking
keeking114210893kee_king
keeling123515123kee_ling
keening123713153kee_ning
keeping144012543kee_ping
kvetching2242903kvetching
lacewing1435843lacewing
lacing94626233l_ac_ing
lacking143821543l_acking
lancing103314123lanc_ing
lashing114422893l_ashing
lathing114315693l_athing
laughing1335933laughing
launching1544783launching
leachier1337253leachier
leading93419553l_eading
leafing113313583l_eafing
leaguing1035343leaguing
leaking123616963l_eaking
leaning83721203l_eaning
leaping103215993l_eaping
learning978553learning
leasing83920163l_easing
leaving114216853l_eaving
lechering1538443l_echering
lectin82515013l_ectin_
lectins92515003l_ectins
leech104913213leech___
leeched13369503leech_ed
leeches123911933leech_es
leechlike1842253leechlike
leftwing1532973leftwing
legating102313113legating
legging103912643l_egging
lekking11306503l_ekking
lemming12269393l_emming
lending94118533l_ending
leniting9312353leniting
lensing84015103l_ensing
letting83218533l_etting
leucin839113leuc_in_
leucine938073leuc_ine
leucins938103leuc_ins
leveeing12265963leveeing
leveling122910433leveling
levelling13206973levelling
levering122212503levering
levying1435873l_evying
lichting14268513l_ichting
licking144118283l_icking
loathing1247673loathing
locking143718153l_ocking
locoing102810973l_ocoing
lucking143615833l_ucking
lushing114316113l_ushing
lynchings18233503lynchings
marching164312193marching
matching163512393matching
meeting103314963mee_ting
meshing134513813_meshing
miching152911803_miching
mooching16259063mooching
mouching163110583mouching
mulching16287103mulching
munching16299973munching
naething1236073naething
necking143913893_necking
needing93214423nee_ding
needling10248753needling
neighing1355523neighing
niching133612433_niching
notching14288583notching
ouching134314903_ouching
parching164313053parching
patching163212753patching
peacing124117073peac_ing
pecking164017783_pecking
peeing94618083pee__ing
peeking144414953pee_king
peeling102919873pee_ling
peening103318303pee_ning
peeping123615213pee_ping
peering103520353pee_ring
peeving135112243pee_ving
piecing12410453piec_ing
pinching163711053pinching
pitching163411113pitching
poaching163510833poaching
pooching16328983pooching
pouching163210413pouching
preaching172811163preaching
psyching1934483psyching
punching163310123punching
quenching2443923quenching
ranching141712043ranching
reacting113317893reacting
receding122713763receding
recking144319923_recking
reechier1336673reechier
reeding94124133ree_ding
reedling102414273reedling
reefing114016863ree_fing
reeking123318643ree_king
reeling83126863ree_ling
reesting93118273reesting
reeving113717663ree_ving
refecting152413353refecting
rejecting192211153rejecting
rescuing1139623rescuing
resecting122816483resecting
reteaching1636023reteaching
roaching143210433roaching
ruching133612933_ruching
screeching1843643screeching
searching1538343searching
seceding12288563seceding
seeding93719483see_ding
seedling102610953seedling
seeing74222143see__ing
seeking124016063see_king
seeling83522003see_ling
seeming103216263see_ming
seeping103817913see_ping
selecting12310533selecting
sketching1935083sketching
sleeking133410963slee_king
sleeping113812053slee_ping
sleeting93114163slee_ting
sleeving12359283slee_ving
sleighing1434213sleighing
sleuthing1334203sleuthing
slouching15195723slouching
speccing15306643speccing
specking17359733specking
synching17227713synching
teachings15296553teachings
teeing73916973tee__ing
teeming103513093tee_ming
teethings1344233teethings
torching142510083torching
touching143211343touching
trenching15227653trenching
veering113213683vee_ring
vetchling1843593vetchling
vouching17308233vouching
watching173011173watching
weeding123815213wee_ding
weening114113973wee_ning
weeping133613673wee_ping
weeting113816053wee_ting
weighing1635283weighing
welshing15296523welshing
winching17359903winching
witching173410633witching
wrecking18328153wrecking
wrenching18276273wrenching
zecchin2343703zecchin_
zecchini2442383zecchini
zecchino2442663zecchino
zecchins2443533zecchins
zechin20137703_zechin_
zechins21137123_zechins

Search took 8 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.1701051123.5
2DLD Change Limit1461622867.51619446.8
3Display Results2862860.1102600.0
 (SQL Overall)1786912867.79622920.9
 
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.