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

274 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
fetching1729841(None) 
etching134511841_etching
fletching18256141fletching
letching143810261letching
retching143412171retching
batching163712092batching
beaching164114142beaching
belching16349152belching
benching163411342benching
bitching163610622bitching
botching16359702botching
catching163712772catching
detaching1637262detaching
ditching15349942ditching
eching126315562_e_ching
etchings14396292_etchings
fencing132411132fenc_ing
fetchingly2242722fetchingly
feting104417792fet__ing
fetting113517872fet_ting
fettling1266772fettling
filching1736112filching
fleeching18305012fleeching
flenching18296702flenching
fletchings19282862fletchings
flitching18265342flitching
frenching18267752frenching
hatching173312212hatching
hitching173310522hitching
hotching17309312hotching
hutching17318642hutching
itching134011682_itching
kvetching2242902kvetching
latching143712022latching
leaching143012832leaching
leching134613652le_ching
leeching14318372leeching
matching163512392matching
notching14288582notching
patching163212752patching
peaching163613642peaching
peching154513902pe_ching
perching163711632perching
pitching163411112pitching
reaching143317202reaching
sketching1935082sketching
teaching143612602teaching
vetchling1843592vetchling
watching173011172watching
welching17287362welching
wenching17328862wenching
witching173410632witching
aching126521973__aching
arching136216693_arching
attaching1545433attaching
baching156017753_baching
bathing134816243bat_hing
becking164416073be_cking
berthing14209593berthing
betaking153010153betaking
bethink1677203bet_hink
betiding1239913betiding
betting103921403bet_ting
bewitching2162773bewitching
birching16328463birching
bleaching17287093bleaching
blenching17276503blenching
blotching1734963blotching
breaching17269403breaching
breeching17236473breeching
bunching163410703bunching
caching156317503_caching
cinching163310223cinching
clenching17266303clenching
clutching17154823clutching
coaching164011963coaching
couching163213263couching
crutching17216073crutching
deashing134210953deashing
decking153915593de_cking
deicing11312193deic_ing
detecting13259983detecting
deticking1736043deticking
detoxing1736313detoxing
deucing1139393deuc_ing
douching15349843douching
drenching16256033drenching
echini114710433_e_chini
echoing1358613_e_choing
etchant1249813_etchant
euchring1436613_euchring
facing125321573f_ac_ing
faithing1537153faithing
fancying1735353fancying
farcing133514003farc_ing
farthing1538073farthing
fashing144918793f_ashing
fating105328673fat__ing
fatling113815683fat_ling
fatting113818703fat_ting
fearing113520033fe_aring
feasing113916653fe_asing
feasting122011323feasting
featuring1337323featuring
feazing205411443fe_azing
fedexing2034493fedexing
feeding123515073fe_eding
feeing104416503fe__eing
feeling113617073fe_eling
feezing204610163fe_ezing
feigning1335813feigning
feinting123410833feinting
felling113321133fe_lling
felting113515213fe_lting
fencings14225663fenc_ings
fending123717603fe_nding
feoffing1432963feoffing
ferrying15146243ferrying
feruling1258873feruling
fessing113812863fe_ssing
festering132413173festering
fetch134913473fetch___
fetched163710473fetch_ed
fetcher153510393fetch_er
fetchers16328863fetchers
fetches153413893fetch_es
fetichism1943663fetichism
fettering132310513fettering
fettlings1353753fettlings
feuding123410263fe_uding
feuing104412273fe__uing
fevering152510083fevering
fishing143913863f_ishing
fitting113516563fit_ting
flacking184311793flacking
flashing153711553flashing
flecking18408233flecking
fleecing14347573fleec_ing
fleshing15339303fleshing
flicking184110043flicking
flinching18245833flinching
floccing16306033floccing
flocking183410873flocking
flushing15288833flushing
forcing134013753forc_ing
frescoing1544683frescoing
freshing152611023freshing
fretting122711523fret_ting
frocking18309573frocking
frothing15208533frothing
fucking173212283f_ucking
futzing20307903fut_zing
gecking154111363ge_cking
getting93316563get_ting
grutching16224373grutching
hatchings18225673hatchings
hatchling1844953hatchling
hunching17309113hunching
inching134414323_inching
itchings14386193_itchings
jetting153815343jet_ting
jettying1933953jettying
katchina1745333katchina
kecking134111883ke_cking
kithing153411553kit_hing
kything18285523kyt_hing
lathing114315693lat_hing
leashing123310313leashing
letting83218533let_ting
lunching143110003lunching
lurching14277333lurching
lynching17336083lynching
marching164312193marching
meshing134513813me_shing
metaling111613723metaling
metering112915633metering
meting94320593met__ing
metring103215293met_ring
miching152911803_miching
mooching16259063mooching
mouching163110583mouching
mulching16287103mulching
munching16299973munching
naething1236073naet_hing
necking143913893ne_cking
neighing1355523neighing
netting84018763net_ting
nettling957213nettling
niching133612433_niching
nothing113511903not_hing
ouching134314903_ouching
parching164313053parching
peacing124117073peac_ing
pecking164017783pe_cking
petering112516813petering
petting103720953pet_ting
pettling1168213pettling
pinching163711053pinching
pithing134014053pit_hing
pleaching17257083pleaching
poaching163510833poaching
pooching16328983pooching
pouching163210413pouching
preaching172811163preaching
psyching1934483psyching
punching163310123punching
quenching2443923quenching
ranching141712043ranching
reacting113317893reacting
recking144319923re_cking
reechoing1545293reechoing
rematching1844913rematching
repatching1844993repatching
rescuing1139623rescuing
retacking1658973retacking
retaking133114283retaking
retaping113012553retaping
retaxing162311333retaxing
reteaching1636023reteaching
rethink1488883ret_hink
retieing92913713retieing
retiling93319483retiling
retiming113014193retiming
retiring92717413retiring
retouching1644693retouching
retrying122410453retrying
retting83425883ret_ting
retuning9311583retuning
retying113213833ret_ying
retyping14255613retyping
roaching143210433roaching
ruching133612933_ruching
scotching1735653scotching
scutching1735223scutching
searching1538343searching
seething1239023seething
setting83621393set_ting
settling978943settling
smutching1734853smutching
snatching1536363snatching
snitching1535913snitching
stitching1547103stitching
stretching1645813stretching
switching1835703switching
synching17227713synching
teachings15296553teachings
teething1237163teething
tetchier1336453tetchier
tetchily1644123tetchily
thatching1835143thatching
thing96622983__t_hing
tithing113513893tit_hing
torching142510083torching
touching143211343touching
trenching15227653trenching
twitching1834243twitching
tything14316573tyt_hing
vetchlings1951703vetchlings
vetoing11309053vet_oing
vetting114216563vet_ting
vouching17308233vouching
weighing1635283weighing
welshing15296523welshing
wetting114117383wet_ting
winching17359903winching
witchings18325303witchings
withing143814493wit_hing
wrenching18276273wrenching
zecchin2343703zecchin_
zecchini2442383zecchini
zecchino2442663zecchino
zecchins2443533zecchins
zechin20137703ze_chin_
zechins21137123ze_chins

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.1561145455.1
2DLD Change Limit1461622748.00018270.3
3Display Results2742740.0932946.2
 (SQL Overall)1786912748.24921662.1
 
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.