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

540 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
fainting12331216(None) 
feinting123410831feinting
flinting123412341flinting
painting113614421painting
sainting93215731sainting
tainting93613581tainting
airting83616302_airting
anting75827022_a_nting
baiting103918882bai_ting
canting104725902ca_nting
daunting103310402daunting
dinting93520552_dinting
faceting1438782faceting
fagoting1336282fagoting
failing113521332fai_ling
faintish1446192faintish
fairing113614012fai_ring
faithing1537152faithing
fanning113615072fa_nning
farting114120752fa_rting
fasting114522832fa_sting
fating105328672fa__ting
fatting113818702fa_tting
faulting12237732faulting
fawning14409132fawn_ing
finding124116542f_inding
fining104223212f_in_ing
finking154016602f_inking
finning113615112f_inning
fisting113818122f_isting
fitting113516562f_itting
flaunting1335042flaunting
flinging133310052flinging
flirting12319012flirting
fliting113514612fli_ting
flitting123010882flitting
foining113013452foin_ing
foisting122910502foisting
fringing133010902fringing
fritting123510702fritting
fronting12310442fronting
gaining94015662gain_ing
gaiting93716582gai_ting
glinting103210052glinting
hanting114124482ha_nting
haunting123510052haunting
hinting113919222_hinting
jaunting16328632jaunting
jointing16248612jointing
linting83820982_linting
minting103020812_minting
paining103920242pain_ing
paintings12327102paintings
panting104025422pa_nting
pointing112813682pointing
printing113216082printing
raining83922692rain_ing
ranting84025412ra_nting
saining83621392sain_ing
stinting93415742stinting
taunting93510932taunting
tinting84620602_tinting
vaunting12338752vaunting
waisting123615212waisting
waiting113618952wai_ting
wanting114220172wa_nting
abating10413973_abating
acting95920983_a_cting
agenting1039383agenting
agisting1038243agisting
aiding84423613_ai_ding
ailing74331013_ai_ling
aiming94320843_ai_ming
airing74927503_ai_ring
airthing12297953_airthing
alining81917043alin_ing
anointing1038623anointing
anteing8312813_a_nteing
antings85015583_a_ntings
arointing1049363arointing
attainting1144783attainting
aviating12311023aviating
awaiting1238273awai_ting
awning105013393_awn_ing
bailing103723523bai_ling
banding114921413ba_nding
banging114019863ba_nging
baning95127833ba_n_ing
banking144621353ba_nking
banning103818233ba_nning
banteng1046363ba_nteng
bantling112612003ba_ntling
barning104320353barn_ing
basting104227203ba_sting
bating95132253ba__ting
batting104422273ba_tting
bepainting15144883bepainting
binding113819383_binding
binging113619383_binging
binning103615453_binning
biting95321823_bi_ting
bitting103717293_bitting
blinding123210163blinding
blinking153510623blinking
blunting11319843blunting
boinking15378423boinking
braining113414683brain_ing
bringing123011273bringing
brining103216473brin_ing
bunting103718833_bunting
cabining1338643cabin_ing
caning94128623ca_n_ing
canning103620133ca_nning
cantina93417253ca_ntina
carting104228283ca_rting
casting104628343ca_sting
catting103922643ca_tting
chaining142810783chain_ing
chanting143413533chanting
chaunting1555413chaunting
chining133316843chin_ing
chinking183210893chinking
chinning14329653chinning
citing94220183_ci_ting
clinging122910913clinging
clinking153611663clinking
coining103920553coin_ing
counting113115273counting
cringing123311383cringing
daintier937403daintier
dainties9312403dainties
daintily1245523daintily
dairying1336353dairying
damning114211633damn_ing
dancing113611563da_ncing
danging103716093da_nging
darning93817333darn_ing
darting94020663da_rting
dating85326483da__ting
dauting93814763da_uting
dawning124111013dawn_ing
dawting123610673da_wting
denting94422183_denting
depainting14156153depainting
dieting93616833_dieting
dinging103618613_dinging
dining84525133_din_ing
dinking133618283_dinking
dinning93416553_dinning
draining103312673drain_ing
drifting13338733drifting
drinking14308913drinking
dunting93418383_dunting
dwining12269293dwin_ing
eanling81416673ea_nling
earning83418213earn_ing
easting84924303ea_sting
eating75134403ea__ting
editing9313133edi_ting
emitting112410353emitting
evicting1437483evicting
evincing1446183evincing
eviting11511373evi_ting
existing1639073existing
exiting15311393exi_ting
fabling133413623fa_bling
facetting1535283facetting
facing125321573fa__cing
fadging134210243fa_dging
fading114821113fa__ding
fagging133714763fa_gging
faggoting1543313faggoting
fagotings1443153fagotings
failings123811013fai_lings
faineant1146743faineant
faint85837063faint___
fainted114211723faint_ed
fainter103611053faint_er
fainters11349693fainters
faintest1139073faintest
faintly1337083faint_ly
faints94818783faint__s
fairings12388193fai_rings
faking145520983fa__king
falling113621583fa_lling
faming124922973fa__ming
famishing1845233famishing
fancying1735353fancying
fanzine1937123fa_nzine
farcing133514003fa_rcing
farding123716743fa_rding
faring105231283fa__ring
farming133515083fa_rming
farthing1538073farthing
fascinating1745253fascinating
fashing144918793fa_shing
fastings124011943fa_stings
fatiguing1443053fatiguing
fatling113815683fa_tling
favoring1596673favoring
faxing175117053fa__xing
faying134521073fa__ying
fazing194418643fa__zing
feasting122011323feasting
feigning1335813feigning
felting113515213f_elting
fencing132411133f_encing
fending123717603f_ending
feting104417793f__eting
fetting113517873f_etting
fibbing15339463f_ibbing
fidging133910503f_idging
fifing134212343f_i_fing
figging133313563f_igging
fighting162710083fighting
fileting1239303fileting
filiating1339253filiating
filing103823763f_i_ling
filling113520803f_illing
filming133210353f_ilming
findings13328443f_indings
finiking16277073f_iniking
finings114311773f_in_ings
firing104021723f_i_ring
firming132811223f_irming
fishing143913863f_ishing
fittings12318203f_ittings
fixating1936183fixating
fixing174813783f_i_xing
fizzing19276403f_izzing
flailing12298923flai_ling
flanging132710583flanging
flanking164211083flanking
flatting123511253flatting
fleeting122910323fleeting
flensing1246973flensing
flicking184110043flicking
flighting1736103flighting
flinching18245833flinching
flintier1136393flintier
flintily1434893flintily
flipping16307663flipping
floating123111883floating
flouting122610473flouting
flunking16317773flunking
fluting113815093f_luting
flyting14378553f_lyting
foiling113317653foi_ling
foliating1339253foliating
fomenting1537233fomenting
fonding123815423f_onding
fontina1038633f_ontina
footing115017593f_ooting
founding133010793founding
franking164310863franking
fretting122711523fretting
friending1495553friending
frigging14268953frigging
frighting1736023frighting
frilling123011493frilling
frisking16268363frisking
frizing203310873fri_zing
frizzing2064803frizzing
frosting12311183frosting
fruiting12229063fruiting
funding124113663f_unding
funking154013023f_unking
funning113813613f_unning
ganging103216193ga_nging
garoting10510703garoting
gasting95022763ga_sting
gating84826953ga__ting
gifting123810893_gifting
ginning93313983_ginning
girting93113333_girting
gitting93215703_gitting
graining102813183grain_ing
granting103514523granting
grifting13299263grifting
grinding1139863grinding
grinning1037863grinning
gritting10309983gritting
grunting10269583grunting
habiting1437533habiting
hafting144014173ha_fting
hailing113820693hai_ling
halting114419073ha_lting
handing123518893ha_nding
hanging123518703ha_nging
hanking154619103ha_nking
hasting114725193ha_sting
hating104929713ha__ting
hatting113920233ha_tting
heisting123411043heisting
henting113719653_henting
hilting113316893_hilting
hinging123917123_hinging
histing113720373_histing
hitting113017273_hitting
hoisting123610903hoisting
hunting114317123_hunting
igniting1037363igniting
impainting1544503impainting
inking115119053__inking
inning73617633__inning
intine61021983__intine
jailing153415843jai_ling
jauncing18314783jauncing
jilting153211743_jilting
jinking193613543_jinking
jinxing22306503_jinxing
joining153011483join_ing
joisting16328503joisting
karting123716063ka_rting
kilting123213853_kilting
kinging133115033_kinging
kinking113615153_kinking
kiting114117093_ki_ting
kitting123214443_kitting
knitting13257023knitting
lairing83715343lai_ring
lamenting1237703lamenting
laminating1348733laminating
lancing103314123la_ncing
landing92819323la_nding
lariating10311793lariating
lasting84725243la_sting
leniting9312353leniting
lifting113313273_lifting
lilting83515383_lilting
lining74526803_lin_ing
linking123818253_linking
listing84020593_listing
lunting83817743_lunting
mailing102923343mai_ling
maiming122912723mai_ming
mainline1039863mainline
maintain1077723maintain_
maintains1167103maintains
malting103219083ma_lting
manning103616383ma_nning
mantling112012613ma_ntling
marinating13410273marinating
marting103325013ma_rting
masting104325823ma_sting
mating94832913ma__ting
matting103620143ma_tting
milting103619123_milting
mincing123314333_mincing
minding113317893_minding
mining94225453_min_ing
minuting1139723_minuting
misting103623383_misting
mounting112711813mounting
munting103718773_munting
nailing83419963nai_ling
oinking123714713_oinking
omitting11217743omitting
opiating11410093opiating
opining10311743opin_ing
orienting1038723orienting
paginating1447533paginating
paiking143814813pai_king
paintier1048793paintier
pairing103716733pai_ring
panging113319113pa_nging
panning104019393pa_nning
parenting12611583parenting
parting103527383pa_rting
pasting103826553pa_sting
patenting1248953patenting
patinating1339883patinating
patining11312303patin_ing
patting103722343pa_tting
pawning134711413pawn_ing
peining104619153pein_ing
pinging113419553_pinging
pining93726533_pin_ing
pinking143918943_pinking
pinning103417853_pinning
pitting103618873_pitting
plaining113911553plain_ing
plaiting113113513plai_ting
planting113515383planting
plinking153611243plinking
poinding122510003poinding
prinking153212453prinking
printings12268113printings
punting103318443_punting
quanting1849233quanting
quieting18228463quieting
quilting18218713quilting
quintin163810333quintin_
quintins17329863quintins
quirting18238383quirting
quitting18228833quitting
radiating111112133radiating
rafting113815753ra_fting
raiding93617593rai_ding
railing83325643rai_ling
raising83220533rai_sing
ranging94120263ra_nging
ranking124320883ra_nking
rating74938703ra__ting
ratting83822363ra_tting
ravining12269693ravin_ing
reining84425323rein_ing
reinking13311023reinking
reminting122315103reminting
renting84026853_renting
repainting13128973repainting
retinting102215253retinting
rifting113515003_rifting
ringing93521283_ringing
rinning83216743_rinning
rinsing82516113_rinsing
rioting82716393_rioting
ruinating1039593ruinating
ruining83514883ruin_ing
sailing83927373sai_ling
salting84120793sa_lting
saluting9310553saluting
sanding93520603sa_nding
saning75127643sa_n_ing
satiating10311813satiating
sating74735453sa__ting
saunaing937013saunaing
scanting113914763scanting
scenting113212813scenting
seining84020773sein_ing
shifting152910383shifting
shining113816523shin_ing
shinning123211023shinning
shirting123213613shirting
shitting123212663shitting
shunting123610433shunting
sifting113014593_sifting
silting83320483_silting
singing93221423_singing
sinking123320543_sinking
sinning83918443_sinning
siting74126623_si_ting
sitting83519633_sitting
skinking12299773skinking
skinning13327893skinning
skirting13289393skirting
skiting123812503ski_ting
slanting94115093slanting
slinging103312863slinging
slinking133412983slinking
slitting93012583slitting
smiting103014443smi_ting
spinning113310813spinning
spirting112913633spirting
spiting103917623spi_ting
spitting113012323spitting
splinting1238193splinting
sprinting12310033sprinting
squinting1936223squinting
staining9413373stain_ing
stilting93312403stilting
stinging103213453stinging
stinking133113543stinking
stunting92811503stunting
suiting83419003sui_ting
swinging133411113swinging
swinking163410323swinking
tailing82923103tai_ling
tanging93419533ta_nging
tanking123918793ta_nking
tanning83618253ta_nning
tarting84222653ta_rting
tasting84624213ta_sting
tatting84019523ta_tting
tauting83316383ta_uting
tenting84621153_tenting
thinking16289863thinking
thinning12319093thinning
tilting83417103_tilting
tincting1148883_tincting
tinging93619463_tinging
tining74927543_tin_ing
tinning83117283_tinning
tintings9288713_tintings
toiting83217093toi_ting
training93015863train_ing
trining82919213trin_ing
twinging13278423twinging
twining113211443twin_ing
twinning12367043twinning
twisting12427813twisting
twitting12307223twitting
uniting8315823uni_ting
urinating10310653urinating
vacating14310363vacating
vailing113817953vai_ling
valeting1238853valeting
vanning113912463va_nning
variating13310953variating
vatting113614853va_tting
vaulting12227233vaulting
veining114713893vein_ing
venting114218093_venting
vining104619463_vin_ing
wafting143911663wa_fting
waifing142910893wai_fing
wailing113620903wai_ling
wairing113414313wai_ring
waistings1352710763waistings
waitings123413743wai_tings
waiving14329633wai_ving
waning103623803wa_n_ing
wanking154216783wa_nking
wanning113816213wa_nning
warning113717093warn_ing
wasting114422843wa_sting
whinging16247743whinging
whining143311673whin_ing
whisting15329543whisting
whiting143311303whi_ting
wilting113515913_wilting
wincing133413903_wincing
winding123517913_winding
winging123718713_winging
wining103625053_win_ing
winking153317963_winking
winning113516553_winning
wintling12249923_wintling
wisting113519743_wisting
witing103522823_wi_ting
witting113417063_witting
wonting113214103_wonting
wringing13279623wringing
writing113713893wri_ting
yachting1734933yachting
yanking154512463ya_nking
yarning113512953yarn_ing
yawning14378343yawn_ing
zincing192910283_zincing
zinging183513943_zinging

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.423422437.4
2DLD Change Limit1461625408.28317646.0
3Display Results5405400.2002700.0
 (SQL Overall)1786915408.90620064.1
 
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.