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

264 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
fancying173535(None) 
bandying15218072bandying
candying15188992candying
dancing113611562danc_ing
facing125321572fa_c_ing
fancifying2243882fancifying
fanning113615072fan_ning
farcing133514002farc_ing
faying134521072fa__ying
fencing132411132fenc_ing
lancing103314122lanc_ing
pandying15217662pandying
ranching141712042ranching
abying124410413_a_bying
aching126521973_a_ching
acing87429153_a_c_ing
acting95920983_a_cting
allying113011663_allying
aneling82719503_aneling
angling92816043_angling
ankling122912063_ankling
annoying1246543annoying
anteing8312813_anteing
anting75827023_an_ting
arching136216693_arching
arcing95819643_arc_ing
arcking145811963_arcking
babying1537963ba_bying
baching156017753ba_ching
backing165523443ba_cking
banding114921413ban_ding
banging114019863ban_ging
baning95127833ban__ing
banking144621353ban_king
banning103818233ban_ning
bantling112612003bantling
batching163712093batching
baying125222583ba__ying
benching163411343benching
blanching17297093blanching
branching17289263branching
brandying1654883brandying
bunching163410703bunching
buncoing13337813buncoing
caching156317503ca_ching
caddying16225063caddying
canaling112016413canaling
canceling14310163canceling
candling122313873candling
caning94128623can__ing
canning103620133can_ning
canoeing11310213canoeing
canopying1745063canopying
canting104725903can_ting
carrying14148373carrying
catching163712773catching
chancing162810283chanc_ing
cinching163310223cinching
cranching17278733cranching
dairying1336353dairying
dallying13368493dallying
dandling112511733dandling
danging103716093dan_ging
dangling112611233dangling
denying123711293den_ying
eanling81416673ean_ling
enacting11311363enacting
envying1435713_envying
fabling133413623fa_bling
faceting1438783faceting
facings134511263fa_c_ings
fadging134210243fa_dging
fading114821113fa__ding
fagging133714763fa_gging
fagoting1336283fagoting
failing113521333fa_iling
fainting123312163fainting
fairing113614013fa_iring
faithing1537153faithing
faking145520983fa__king
falling113621583fa_lling
faming124922973fa__ming
fancied133310603fanc_ied
fancier123412063fanc_ier
fancies124018783fanc_ies
fancify1834983fanc_ify
fancily1538253fanc_ily
fancy134615483fancy___
fantasying1743563fantasying
fanzine1937123fan_zine
farding123716743fa_rding
faring105231283fa__ring
farming133515083fa_rming
farthing1538073farthing
farting114120753fa_rting
fascine12510583fasc_ine
fashing144918793fa_shing
fasting114522833fa_sting
fating105328673fa__ting
fatling113815683fa_tling
fatting113818703fa_tting
faulting12237733faulting
favoring1596673favoring
fawning14409133fa_wning
faxing175117053fa__xing
fazing194418643fa__zing
fencings14225663fenc_ings
fending123717603fen_ding
ferrying15146253ferrying
fetching17298413fetching
filching1736113filching
financing1544073financ_ing
finding124116543fin_ding
finicking1954463finicking
finiking16277073finiking
fining104223213fin__ing
finking154016603fin_king
finning113615113fin_ning
flacking184311793flacking
flanging132710583flan_ging
flanking164211083flan_king
flaying143914463f_laying
flecking18408233flecking
flenching18296703flenching
fleying14329873f_leying
flicking184110043flicking
flinching18245833flinching
floccing16306033floccing
flocking183410873flocking
flying134612153f__lying
fonding123815423fon_ding
fondling13189353fondling
fonduing13245893fonduing
foraying1537433foraying
forcing134013753forc_ing
francizing2545373francizing
franking164310863fran_king
fraying143413433f_raying
frenching18267753frenching
frenzying2542413frenzying
frocking18309573frocking
frying134511403f__rying
fucking173212283f_ucking
funding124113663fun_ding
funking154013023fun_king
funning113813613fun_ning
gallying13328933gallying
ganging103216193gan_ging
gangling112411403gangling
glancing1247063glanc_ing
hacking173720613ha_cking
handing123518893han_ding
handling132312713handling
hanging123518703han_ging
hanking154619103han_king
hanting114124483han_ting
harrying15157643harrying
hatching173312213hatching
haying134420613ha__ying
hinnying15124853hinnying
honeying1537673honeying
hunching17309113hunching
inching134414323_inching
inlying1168153_inlying
jacking214515263ja_cking
jangling17249623jangling
jauncing18314783jaunc_ing
knacking14296713knacking
lacing94626233la_c_ing
lacking143821543la_cking
landing92819323lan_ding
latching143712023latching
launching1544783launching
laying104525703la__ying
lazying2046673la_zying
lunching143110003lunching
lynching17336083lynching
macing114221553ma_c_ing
manacling1446283manacling
managing1239093managing
mangling122312623mangling
manning103616383man_ning
mantling112012613mantling
manuring1139223manuring
marching164312193marching
marrying14157233marrying
matching163512393matching
maying124421153ma__ying
mincing123314333minc_ing
munching16299973munching
noncling11310763noncling
pacing114522753pa_c_ing
packing164420723pa_cking
palsying1436233palsying
pancaking1836383pancaking
paneling111013633paneling
panfrying1842993panfrying
panging113319113pan_ging
panicking1835293panicking
panning104019393pan_ning
panting104025423pan_ting
parching164313053parching
parrying14168133parrying
partying14168893partying
patching163212753patching
paying123722163pa__ying
pinching163711053pinching
poncing122913583ponc_ing
ponying133312123pon_ying
prancing132612163pranc_ing
punching163310123punching
racing95030533ra_c_ing
racking144323663ra_cking
rallying12289013rallying
ranging94120263ran_ging
ranking124320883ran_king
rankling132610113rankling
ranting84025413ran_ting
raying105027193ra__ying
sacking144122703sa_cking
sacring103115983sa_cring
sallying12309853sallying
sanding93520603san_ding
sandling102214413sandling
saning75127643san__ing
saucing10311003sauc_ing
savvying1862723savvying
saying104325543sa__ying
snacking153411703snacking
stanching1538083stanching
synching17227713synching
syncing13177223sync_ing
tabbying1633973tabbying
tacking144421483ta_cking
talcing103111633talc_ing
talcking1567083talcking
tallying12318833tallying
tanging93419533tan_ging
tangling101712543tangling
tangoing10177893tangoing
tanking123918793tan_king
tanning83618253tan_ning
tarrying12146723tarrying
taxying1836183ta_xying
tincting1148883tincting
trancing112812023tranc_ing
undying1238503_undying
untying1138943_untying
vanning113912463van_ning
varying1429723va_rying
waddying17204723waddying
wangling132310993wangling
waning103623803wan__ing
wanking154216783wan_king
wanning113816213wan_ning
wanting114220173wan_ting
watching173011173watching
wenching17328863wenching
winching17359903winching
wincing133413903winc_ing
yacking174315683ya_cking
yanking154512463yan_king
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.423422437.4
2DLD Change Limit1461622646.59322169.3
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.12625075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.