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

340 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
fielding1320686(None) 
bielding12237471bielding
wielding13286861wielding
yielding13205031yielding
feeding123515072f_eeding
feeling113617072feel_ing
felling113321132f_elling
felting113515212f_elting
fending123717602f_ending
feuding123410262f_euding
fiddling14217872fiddling
fileting1239302fileting
filing103823762fi_l_ing
filling113520802fi_lling
filming133210352fi_lming
finding124116542fi_nding
folding123912442f_olding
friending1495552friending
fueling113615132fuel_ing
fuelling123410152fuelling
gelding103911792_gelding
gilding103813002gi_lding
hilding123713532hi_lding
melding113414272_melding
milding113615452mi_lding
shielding1434552shielding
welding123213252_welding
wilding123814292wi_lding
aiding84423613ai__ding
ailing74331013ai_l_ing
amending12308913amending
aneling82719503anel_ing
balding114015063_balding
beading113221863_beading
bedding124114483_bedding
belling103825073_belling
belting104119133_belting
belying133612443_belying
bending114420893_bending
bidding123613513bi_dding
biding104720793bi__ding
bilging114212683bi_lging
bilking144413553bi_lking
billing103823853bi_lling
binding113819383bi_nding
birding114014923bi_rding
birling104317053birl_ing
bleeding12359053bleeding
blending12249963blending
breading123515463breading
breeding123411843breeding
building1237503building
ceding104014803_ce_ding
ceiling103416723ceil_ing
celling103921263_celling
childing15288503childing
deeding103315123_deeding
deleing93313953_deleing
deluding1137683_deluding
delving123711573_delving
dialing94318173dial_ing
dialling10310783dialling
diddling12228743diddling
dieing84018653die__ing
dieldrin1093983dieldrin_
dieldrins1193753dieldrins
dieting93616833die_ting
dindling112411163dindling
dirling93316073dirl_ing
dividing1437183dividing
dreading113712803dreading
dueling93614543duel_ing
duelling103410733duelling
dwelling13368413dwelling
eliding93414343__eliding
eluding93412113__eluding
emending12298893emending
ending83220253__ending
fabling133413623fabl_ing
fading114821113f__ading
failing113521333fail_ing
falling113621583f_alling
farding123716743f_arding
fatling113815683fatl_ing
faulting12237733faulting
fearing113520033f_earing
feasing113916653f_easing
feazing205411443f_eazing
feeing104416503f_e_eing
feelings12338933feel_ings
feezing204610163f_eezing
feigning1335813feigning
feinting123410833feinting
feline94820143f_el_ine
feltings12317903f_eltings
fencing132411133f_encing
fessing113812863f_essing
feting104417793f_e_ting
fetting113517873f_etting
feuing104412273f_e_uing
fibbing15339463fi_bbing
fidging133910503fi_dging
field95015323field___
fielded12206813field_ed
fielder11217413field_er
fielders12156773fielders
fields104211043field__s
fiendish1544033fiendish
fifing134212343fi__fing
figging133313563fi_gging
fighting162710083fighting
figuring1336283figuring
filching1736113filching
filings115213073fi_l_ings
filleting1335853filleting
fillings122910503fi_llings
filliping1544233filliping
findings13328443fi_ndings
finessing1345123finessing
finiking16277073finiking
fining104223213fi__ning
finking154016603fi_nking
finning113615113fi_nning
firing104021723fi__ring
firming132811223fi_rming
fishing143913863fi_shing
fisting113818123fi_sting
fitting113516563fi_tting
fixating1936183fixating
fixing174813783fi__xing
fizzing19276403fi_zzing
fizzling20264993fizzling
flecking18408233flecking
fledging14276523fledging
fleecing14347573fleecing
fleeing113511293fle_eing
fleering123811283fleering
fleeting122910323fleeting
flensing1246973flensing
fleshing15339303fleshing
flexing18358993fle_xing
fleying14329873fle_ying
fling97023513f__l_ing
flooding13238963flooding
flying134612153f__lying
foaling113515843foal_ing
foiling113317653foil_ing
fonding123815423f_onding
fondling13189353fondling
fooling113117373fool_ing
fording123717043f_ording
fouling113315373foul_ing
founding133010793founding
fowling143713113fowl_ing
freaking163611453freaking
freeing113713913fre_eing
freezing21308323freezing
freshing152611023freshing
fretting122711523fretting
frilling123011493frilling
fuddling14247153fuddling
fugling124212513fugl_ing
fulling114019703f_ulling
funding124113663f_unding
furling114016563furl_ing
geldings11316163_geldings
gelling93219763_gelling
gieing83614853gie__ing
gildings11356973gi_ldings
gilling93520383gi_lling
gillying13306813gillying
girding103611883gi_rding
girdling1146823girdling
heading122919113_heading
heeding123515063_heeding
heeling113618513heel_ing
heiling113616363heil_ing
helling114623223_helling
helming133712003_helming
helping133512223_helping
helving144011133_helving
herding122915123_herding
hiding114319333hi__ding
hieing104216623hie__ing
hildings13347503hi_ldings
hilling113821773hi_lling
hilloing12158303hilloing
hilting113316893hi_lting
hireling121210993hirel_ing
holding123514283_holding
idling8912883_idl_ing
illuding1035803_illuding
inlying1168153_inlying
isling71213883_isl_ing
jelling153516613_jelling
jilting153211743ji_lting
keeling123515123keel_ing
kelping14319193_kelping
kidding14389773ki_dding
killing123118723ki_lling
kilning12289023ki_lning
kilting123213853ki_lting
kindling14229623kindling
kitling123313573kitl_ing
kneading1436373kneading
knelling13319023knelling
kvelling16146513kvelling
leading93419553_leading
lending94118533_lending
libeling1139873libel_ing
libelling1236883libelling
lidding103611433li_dding
lilting83515383li_lting
melling102822633_melling
melting103317753_melting
mending114018683_mending
middling13249343middling
milking143712763mi_lking
milling103223683mi_lling
milting103619123mi_lting
minding113317893mi_nding
misfielding1842723misfielding
mislying1437843mislying
molding114213753_molding
moulding12258143moulding
needing93214423_needing
needling10248753needling
niding83217983ni__ding
nielloing1043893nielloing
nilling83619563ni_lling
offending1744093offending
oiling74925313oi_l_ing
peeling102919873peel_ing
pelting102917273_pelting
pending114119773_pending
piddling13208953piddling
piecing12410453pie_cing
pieing93917653pie__ing
piercing1346663piercing
piling95025593pi_l_ing
pilling103722563pi_lling
pindling122110983pindling
pleading123011443pleading
preluding1337053preluding
quelling18259793quelling
reading93327213_reading
redding103218513_redding
reding83825563_re_ding
reeding94124133_reeding
reedling102414273reedling
reeling83126863reel_ing
relying112914613_relying
rending93924263_rending
rewelding1436913rewelding
ridding103314193ri_dding
riddling11249443riddling
riding84325963ri__ding
riesling939013riesling
rifling112815013rifl_ing
riling74227973ri_l_ing
rilling84023623ri_lling
scalding12339393scalding
scending122610583scending
scolding12278913scolding
seeding93719483_seeding
seedling102610953seedling
seeling83522003seel_ing
selfing112911623_selfing
selling83225833_selling
sending94221373_sending
shedding14278113shedding
shelling123515213shelling
shelving15278173shelving
shending132511253shending
shieling123512403shiel_ing
sibling10814423sibl_ing
sideling101012183sidel_ing
siding83822133si__ding
sidling9915423sidl_ing
sieging92613203sie_ging
sieving112311233sie_ving
silking123715593si_lking
siloing83215503si_loing
silting83320483si_lting
skelping1535973skelping
sledding11248503sledding
smelling113712733smelling
smelting11339713smelting
snedding11246953snedding
snelling93913563snelling
speeding122810933speeding
spelling113315233spelling
spending122712433spending
spieling113212523spiel_ing
steading103613593steading
sueding92613753sue_ding
swelling123212753swelling
tedding103210883_tedding
telling83321083_telling
tending94419163_tending
tiding83520093ti__ding
tieing73518763tie__ing
tiering8315253tie_ring
tiling73426553ti_l_ing
tilling83522783ti_lling
tilting83417103ti_lting
tirling83315733tirl_ing
titling83715793titl_ing
treading103515333treading
trending103012833trending
unending10239943unending
unyielding1542473unyielding
upending12258133upending
veiling113615293veil_ing
vending124015263_vending
vialing113614163vial_ing
vialling1237223vialling
viewing1437073vie_wing
wedding133411873_wedding
weeding123815213_weeding
weirding1335593weirding
welling112920313_welling
welting113615313_welting
wending123816843_wending
whelming17304923whelming
whelping17245333whelping
widdling14228743widdling
wieldier1234283wieldier
wildings13287933wi_ldings
wildling13248083wi_ldling
wiling103024293wi_l_ing
willing113821613wi_lling
willying15306713willying
wilting113515913wi_lting
winding123517913wi_nding
windling132212263windling
wingding1436453wingding
witling113215813witl_ing
yelling113516703_yelling
yelping13317873_yelping

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.406440125.6
2DLD Change Limit1461623407.12620511.1
3Display Results3403400.1232764.2
 (SQL Overall)1786913407.65523343.0
 
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.