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

367 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
faithing153715(None) 
farthing1538071farthing
airthing12297952_airthing
baiting103918882bait_ing
bathing134816242ba_thing
earthing12310322earthing
failing113521332fai_ling
fainting123312162fainting
fairing113614012fai_ring
famishing1845232famishing
farthings1635232farthings
farting114120752fart_ing
fashing144918792fa_shing
fasting114522832fast_ing
fating105328672fa_t_ing
fatling113815682fa_tling
fatting113818702fa_tting
fishing143913862f_ishing
fitting113516562f_itting
flitching18265342flitching
fliting113514612flit_ing
flitting123010882flitting
fritting123510702fritting
frothing15208532frothing
gaiting93716582gait_ing
kithing153411552_kithing
lathing114315692la_thing
naething1236072naething
pithing134014052_pithing
tithing113513892_tithing
trithing122811772trithing
waiting113618952wait_ing
withing143814492_withing
writhing15278672writhing
aahing1019015763_a_ahing
aching126521973_a_ching
acting95920983_act_ing
ahing98928353_a__hing
aiding84423613_ai_ding
ailing74331013_ai_ling
aiming94320843_ai_ming
airing74927503_ai_ring
airting83616303_airting
anteing8312813_anteing
anting75827023_ant_ing
anything1534993anything
arching136216693_arching
ashing107824093_a_shing
autoing8314043_autoing
awaiting1238273await_ing
baching156017753ba_ching
bailing103723523bai_ling
banishing1537143banishing
bantling112612003bantling
bashing135422583ba_shing
basting104227203bast_ing
batching163712093batching
batiking1537503batiking
bating95132253ba_t_ing
batting104422273ba_tting
battling113110493battling
batwing13509813ba_twing
berthing14209593berthing
birthing14338433birthing
bitching163610623_bitching
biting95321823_bit_ing
bitting103717293_bitting
blitzing2035903blitzing
caching156317503ca_ching
canting104725903cant_ing
carting104228283cart_ing
cashing135022553ca_shing
casting104628343cast_ing
castling11311233castling
catching163712773catching
catling104819793ca_tling
catting103922643ca_tting
chitling142910663chitling
citing94220183_cit_ing
clothing14278783clothing
dairying1336353dairying
darting94020663dart_ing
dartling1039563dartling
dashing125917893da_shing
dating85326483da_t_ing
dauting93814763daut_ing
dawting123610673dawt_ing
dishing124017103_dishing
ditching15349943_ditching
earthling1346193earthling
easting84924303east_ing
eating75134403ea_t_ing
editing9313133edit_ing
emitting112410353emitting
eviting11511373evit_ing
exiting15311393exit_ing
fabling133413623fa_bling
faceting1438783faceting
facetting1535283facetting
facing125321573fa__cing
factoring1537523factoring
fadging134210243fa_dging
fading114821113fa__ding
fagging133714763fa_gging
fagoting1336283fagoting
failings123811013fai_lings
fairings12388193fai_rings
faith115620853faith___
faithed1437163faith_ed
faithful1743383faithful
faiths124610273faith__s
faking145520983fa__king
falling113621583fa_lling
faltering132211113faltering
faming124922973fa__ming
fancying1735353fancying
fanning113615073fa_nning
farcing133514003fa_rcing
farding123716743fa_rding
faring105231283fa__ring
farming133515083fa_rming
fastening13268603fastening
fastings124011943fast_ings
fathering161010093fa_thering
fathoming1844693fa_thoming
fatiguing1443053fatiguing
fatlings12359303fa_tlings
fattening13287833fattening
faulting12237733faulting
favoring1596673favoring
fawning14409133fa_wning
faxing175117053fa__xing
faying134521073fa__ying
fazing194418643fa__zing
feasting122011323feast_ing
feigning1335813feigning
feinting123410833feinting
felting113515213felt_ing
fetching17298413fetching
feting104417793f_et_ing
fetting113517873f_etting
fettling1266773fettling
fibbing15339463f_ibbing
fidging133910503f_idging
fifing134212343f_i_fing
figging133313563f_igging
fighting162710083f_ighting
filching1736113filching
filing103823763f_i_ling
filling113520803f_illing
filming133210353f_ilming
finding124116543f_inding
fining104223213f_i_ning
finishing1645843finishing
finking154016603f_inking
finning113615113f_inning
firing104021723f_i_ring
firming132811223f_irming
fishings15307693f_ishings
fisting113818123f_isting
fittings12318203f_ittings
fixing174813783f_i_xing
fizzing19276403f_izzing
flailing12298923flai_ling
flashing153711553flashing
flatling123410013flatling
flatting123511253flatting
fleshing15339303fleshing
fletching18256143fletching
flicking184110043flicking
flighting1736103flighting
flinching18245833flinching
flinging133310053flinging
flinting123412343flinting
flipping16307663flipping
flirting12319013flirting
flushing15288833flushing
fluting113815093flut_ing
flyting14378553flyt_ing
foiling113317653foi_ling
foining113013453foi_ning
foisting122910503foisting
footing115017593foot_ing
footling12239923footling
freshing152611023freshing
fretting122711523fretting
frigging14268953frigging
frighting1736023frighting
frilling123011493frilling
fringing133010903fringing
frisking16268363frisking
frizing203310873fri_zing
frizzing2064803frizzing
fruiting12229063fruit_ing
futzing20307903f_utzing
gaining94015663gai_ning
gashing125119233ga_shing
gasting95022763gast_ing
gating84826953ga_t_ing
girthing13256083girthing
gitting93215703_gitting
glitzing1934973glitzing
gritting10309983gritting
habiting1437533habit_ing
hafting144014173haft_ing
hailing113820693hai_ling
halting114419073halt_ing
hanting114124483hant_ing
hashing145020163ha_shing
hasting114725193hast_ing
hatching173312213hatching
hating104929713ha_t_ing
hatting113920233ha_tting
hitching173310523_hitching
hitting113017273_hitting
itching134011683__itching
jailing153415843jai_ling
karting123716063kart_ing
kiting114117093_kit_ing
kitling123313573_kitling
kitting123214443_kitting
knitting13257023knitting
kything18285523_kything
lairing83715343lai_ring
lashing114422893la_shing
lasting84725243last_ing
latching143712023latching
lathings12469853la_things
laughing1335933laughing
lavishing1644553lavishing
lithoing1236743_lithoing
loathing1247673loathing
mailing102923343mai_ling
maiming122912723mai_ming
malting103219083malt_ing
mantling112012613mantling
marching164312193marching
marting103325013mart_ing
mashing134422243ma_shing
masting104325823mast_ing
matching163512393matching
mating94832913ma_t_ing
matting103620143ma_tting
miching152911803_miching
mitring103514143_mitring
mouthing142810243mouthing
naethings1343873naethings
nailing83419963nai_ling
neighing1355523neighing
niching133612433_niching
nighing123410063_nighing
northing12199063northing
nothing113511903_nothing
omitting11217743omitting
paiking143814813pai_king
paining103920243pai_ning
painting113614423painting
pairing103716733pai_ring
panting104025423pant_ing
parching164313053parching
parting103527383part_ing
partying14168893partying
pashing135120513pa_shing
pasting103826553past_ing
patching163212753patching
patining11312303patining
patting103722343pa_tting
pishing134314373_pishing
pitching163411113_pitching
pitting103618873_pitting
pitying132910243_pitying
plaiting113113513plait_ing
plaything1843853plaything
quitting18228833quitting
rafting113815753raft_ing
raiding93617593rai_ding
railing83325643rai_ling
raining83922693rai_ning
raising83220533rai_sing
ralphing1435413ralphing
ranching141712043ranching
ranting84025413rant_ing
rating74938703ra_t_ing
ratting83822363ra_tting
rattling92510873rattling
ravishing1634983ravishing
sailing83927373sai_ling
saining83621393sai_ning
sainting93215733sainting
salting84120793salt_ing
sashing114621473sa_shing
sating74735453sa_t_ing
sauteing937913sauteing
scathing14269703scathing
scything17264883scything
seething1239023seething
shitting123212663shitting
sighing123311663_sighing
siting74126623_sit_ing
sitting83519633_sitting
skiting123812503skit_ing
slitting93012583slitting
smiting103014443smit_ing
snitching1535913snitching
soothing12269973soothing
southing122811823southing
spiting103917623spit_ing
spitting113012323spitting
stitching1547103stitching
stithying1643703stithying
suiting83419003suit_ing
swathing15248713swathing
swishing15277813swishing
switching1835703switching
tailing82923103tai_ling
tainting93613583tainting
tarting84222653tart_ing
tasting84624213tast_ing
tatting84019523ta_tting
tattling9259473tattling
tauting83316383taut_ing
teething1237163teething
thing96622983___thing
tithings12327693_tithings
titling83715793_titling
toiting83217093toit_ing
toothing12278863toothing
trithings13246603trithings
trothing122410843trothing
twitching1834243twitching
twitting12307223twitting
tything14316573_tything
uniting8315823unit_ing
vailing113817943vai_ling
vanishing1646303vanishing
vatting113614853va_tting
wafting143911663waft_ing
waifing142910893wai_fing
wailing113620903wai_ling
wairing113414313wai_ring
waisting123615213waisting
waitering13310713waitering
waitings123413743wait_ings
waiving14329633wai_ving
waltzing2134263waltzing
wanting114220173want_ing
washing145119283wa_shing
wasting114422843wast_ing
watching173011173watching
wattling12258783wattling
weighing1635283weighing
whishing18287183whishing
whiting143311303whit_ing
wishing144114893_wishing
witching173410633_witching
within123611383_within_
withins133511693_withins
witing103522823_wit_ing
witling113215813_witling
witting113417063_witting
worthing15178053worthing
wrathing15248923wrathing
writing113713893writ_ing
xanthin1747043xanthin_
xanthine1847253xanthine
xanthins1846943xanthins
yachting1734933yachting

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 Limit1461623677.40619735.6
3Display Results3673670.1562352.6
 (SQL Overall)1786913677.98222386.7
 
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.