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

275 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
filching173611(None) 
belching16349152belching
birching16328462birching
bitching163610622bitching
cinching163310222cinching
ditching15349942ditching
fetching17298412fetching
fileting1239302fileting
filing103823762fil__ing
filling113520802fil_ling
filming133210352fil_ming
fishing143913862fi_shing
flicking184110042flicking
flinching18245832flinching
flitching18265342flitching
hitching173310522hitching
inching134414322_inching
itching134011682_itching
miching152911802mi_ching
milchig1543652milchi_g
mulching16287102mulching
niching133612432ni_ching
pinching163711052pinching
pitching163411112pitching
welching17287362welching
winching17359902winching
witching173410632witching
aching126521973__aching
ailing74331013ail__ing
airthing12297953airthing
arching136216693_arching
baching156017753_baching
batching163712093batching
beaching164114143beaching
benching163411343benching
bilging114212683bil_ging
bilking144413553bil_king
billing103823853bil_ling
birthing14338433birthing
botching16359703botching
bunching163410703bunching
caching156317503_caching
catching163712773catching
circling1338423circling
clicking173610983clicking
clinching17276123clinching
coaching164011963coaching
couching163213263couching
dicing105718763di_c_ing
dicking153617613di_cking
dilating102714903dilating
diluting10248983diluting
discing113914593disc_ing
discoing12511453discoing
dishing124017103di_shing
douching15349843douching
eching126315563__eching
etching134511843_etching
facing125321573f_ac_ing
failing113521333fail__ing
faithing1537153faithing
falchion1644343falchion
falchions1743913falchions
falling113621583fal_ling
fancying1735353fancying
farcing133514003farc_ing
farthing1538073farthing
fashing144918793f_ashing
felling113321133fel_ling
felting113515213fel_ting
fencing132411133fenc_ing
fibbing15339463fi_bbing
ficin103516723fi_c_in_
ficins113513983fi_c_ins
fiddling14217873fiddling
fidging133910503fi_dging
fielding13206863fielding
fifing134212343fi__fing
figging133313563fi_gging
fighting162710083fighting
figuring1336283figuring
filch134813323filch___
filched16307423filch_ed
filcher15377793filch_er
filchers16286863filchers
filches153410723filch_es
filiating1339243filiating
filings115213073fil__ings
filleting1335843filleting
fillings122910503fil_lings
filliping1544233filliping
filmgoing1641713filmgoing
filtering13199723filtering
filthier1434073filthier
filthily1743663filthily
finding124116543fi_nding
finicking1954463finicking
finiking16277073finiking
fining104223213fi__ning
finishing1645843finishing
finking154016603fi_nking
finning113615113fi_nning
firing104021723fi__ring
firming132811223fi_rming
fishings15307693fi_shings
fisting113818123fi_sting
fitting113516563fi_tting
fixating1936183fixating
fixing174813783fi__xing
fizzing19276403fi_zzing
fizzling20264993fizzling
flacking184311793flacking
flaking154114493f_laking
flaming134216443f_laming
flaring114116803f_laring
flashing153711553flashing
flawing143812563f_lawing
flaying143914463f_laying
flecking18408233flecking
fleeching18305013fleeching
fleeing113511293f_leeing
flenching18296703flenching
fleshing15339303fleshing
fletching18256143fletching
flexing18358993f_lexing
fleying14329873f_leying
flighting1736103flighting
fling97023513f_l__ing
flinging133310053flinging
flinting123412343flinting
flipping16307663flipping
flirting12319013flirting
fliting113514613f_liting
flitting123010883flitting
floccing16306033floccing
flocking183410873flocking
flowing143411763f_lowing
fluking154410513f_luking
fluming133512793f_luming
flushing15288833flushing
fluting113815093f_luting
fluxing18398923f_luxing
flying134612153f_l_ying
flyting14378553f_lyting
foiling113317653foil__ing
folding123912443fol_ding
folioing1237573folioing
forcing134013753forc_ing
frenching18267753frenching
freshing152611023freshing
frilling123011493fril_ling
frocking18309573frocking
frothing15208533frothing
fucking173212283f_ucking
fulling114019703ful_ling
gilding103813003gil_ding
gilling93520383gil_ling
gillying13306813gillying
girthing13256083girthing
hatching173312213hatching
hilding123713533hil_ding
hilling113821773hil_ling
hilloing12158303hilloing
hilting113316893hil_ting
hotching17309313hotching
hunching17309113hunching
hutching17318643hutching
icing86017753_i_c_ing
itchings14386193_itchings
jilting153211743jil_ting
kicking133314023ki_cking
killing123118723kil_ling
kilning12289023kil_ning
kilting123213853kil_ting
kithing153411553ki_thing
latching143712023latching
leaching143012833leaching
leching134613653_leching
leeching14318373leeching
letching143810263letching
lichting14268513li_chting
licking144118283li_cking
lilting83515383lil_ting
lunching143110003lunching
lurching14277333lurching
lynching17336083lynching
marching164312193marching
matching163512393matching
milding113615453mil_ding
milking143712763mil_king
milling103223683mil_ling
milting103619123mil_ting
mincing123314333minc_ing
miscuing1338733miscuing
mooching16259063mooching
mouching163110583mouching
mulcting13246983mulcting
munching16299973munching
nicking143516323ni_cking
nighing123410063ni_ghing
nilling83619563nil_ling
notching14288583notching
oiling74925313oil__ing
ouching134314903_ouching
parching164313053parching
patching163212753patching
peaching163613643peaching
peching154513903_peching
perching163711633perching
picking163418333pi_cking
piecing12410453piec_ing
piling95025593pil__ing
pilling103722563pil_ling
piloting1139693piloting
pishing134314373pi_shing
pithing134014053pi_thing
poaching163510833poaching
pooching16328983pooching
pouching163210413pouching
psyching1934483psyching
punching163310123punching
ralphing1435413ralphing
ranching141712043ranching
reaching143317203reaching
retching143412173retching
ricing94822763ri_c_ing
ricking143920233ri_cking
riling74227973ril__ing
rilling84023623ril_ling
roaching143210433roaching
ruching133612933_ruching
siccing12319513si_ccing
sicking143720173si_cking
sighing123311663si_ghing
silking123715593sil_king
siloing83215503sil_oing
silting83320483sil_ting
slicing103514643slic_ing
slicking153712593slicking
smirching1744393smirching
snitching1535913snitching
stitching1547103stitching
switching1835703switching
synching17227713synching
talcing103111633talc_ing
talcking1567083talcking
teaching143612603teaching
ticcing12308633ti_ccing
ticking143218753ti_cking
tiling73426553til__ing
tilling83522783til_ling
tilting83417103til_ting
tincting1148883tincting
tithing113513893ti_thing
torching142510083torching
touching143211343touching
twitching1834243twitching
vicing124014243vi_c_ing
vouching17308233vouching
watching173011173watching
welshing15296523welshing
wenching17328863wenching
wicking173414773wi_cking
wilding123814293wil_ding
wildling13248083wildling
wiling103024293wil__ing
willing113821613wil_ling
willying15306713willying
wilting113515913wil_ting
wincing133413903winc_ing
wishing144114893wi_shing
witchings18325303witchings
withing143814493wi_thing
zincing192910283zinc_ing
zincking2435463zincking

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.420425454.8
2DLD Change Limit1461622757.26620115.9
3Display Results2752750.1102500.0
 (SQL Overall)1786912757.79622920.9
 
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.