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

258 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
naething123607(None) 
naethings1343871naethings
anything1534992anything
bathing134816242ba_thing
earthing12310332earthing
faithing1537152faithing
farthing1538072farthing
lathing114315692la_thing
netting84018762n_etting
northing12199062northing
nothing113511902n_othing
seething1239022seething
teething1237162teething
aahing1019015763_a_ahing
abetting1158293abetting
aching126521973_a_ching
acting95920983_act_ing
ahing98928353_a__hing
airthing12297953airthing
anearing9413973anearing
aneling82719503ane_ling
anteing8312813_anteing
anting75827023_ant_ing
anythings1642593anythings
arching136216693_arching
ashing107824093_a_shing
autoing8314043_autoing
baching156017753ba_ching
baiting103918883bait_ing
bantling112612003bantling
bashing135422583ba_shing
basting104227203bast_ing
batching163712093batching
bating95132253ba_t_ing
batting104422273ba_tting
battling113110493battling
batwing13509813ba_twing
beaching164114143beaching
beating104326873beat_ing
beetling1139283beetling
berthing14209603berthing
bethink1677203_bethink
betting103921403_betting
birthing14338433birthing
breathing15218373breathing
caching156317503ca_ching
canting104725903cant_ing
carting104228283cart_ing
cashing135022553ca_shing
casting104628343cast_ing
castling11311233castling
catching163712773catching
catering112019913catering
catling104819793ca_tling
catting103922643ca_tting
clothing14278783clothing
darting94020663dart_ing
dartling1039563dartling
dashing125917893da_shing
dating85326483da_t_ing
dauting93814763daut_ing
dawting123610673dawt_ing
deashing134210953deashing
dieting93616833diet_ing
dueting93814393duet_ing
duetting1047183duetting
earthling1346193earthling
easting84924303east_ing
eating75134403ea_t_ing
eching126315563__eching
enacting11311363enact_ing
enmeshing15114873enmeshing
etching134511843__etching
faceting1438783facet_ing
facetting1535283facetting
farthings1635233farthings
farting114120753fart_ing
fashing144918793fa_shing
fasting114522833fast_ing
fating105328673fa_t_ing
fatling113815683fa_tling
fatting113818703fa_tting
fetching17298413_fetching
feting104417793_fet_ing
fetting113517873_fetting
fleshing15339303fleshing
fletching18256143fletching
freshing152611023freshing
fretting122711523fretting
frothing15208533frothing
gaeing84617223gae__ing
gaiting93716583gait_ing
gashing125119233ga_shing
gasting95022763gast_ing
gating84826953ga_t_ing
gazetting2043243gazetting
getting93316563_getting
girthing13256083girthing
gnashing1336423gna_shing
haeing104118923hae__ing
hafting144014173haft_ing
halting114419073halt_ing
hanting114124483hant_ing
hashing145020163ha_shing
hasting114725193hast_ing
hatching173312213hatching
hating104929713ha_t_ing
hatting113920233ha_tting
heating114024323heat_ing
inarching1546343inarching
inearthing1443543inearthing
inletting1087873inletting
inmeshing1595333inmeshing
insetting1079283insetting
jetting153815343_jetting
karting123716063kart_ing
kithing153411553_kithing
kvetching2242903kvetching
kything18285523_kything
lashing114422893la_shing
lasting84725243last_ing
latching143712023latching
latening9711493latening
lathings12469853la_things
laughing1335933laughing
leaching143012833leaching
leashing123310313leashing
leching134613653_leching
leeching14318373leeching
letching143810263_letching
letting83218533_letting
loathing1247673loathing
malting103219083malt_ing
mantling112012613mantling
marching164312193marching
marting103325013mart_ing
mashing134422243ma_shing
masting104325823mast_ing
matching163512393matching
mating94832913ma_t_ing
matting103620143ma_tting
meeting103314963meet_ing
meshing134513813_meshing
meting94320593_met_ing
metring103215293_metring
mouthing142810243mouthing
nabbing12299963na_bbing
naffing14359033na_ffing
nagging102613043na_gging
nailing83419963na_iling
naming93917893na__ming
napping123514183na_pping
narking124015383na_rking
nattering102212223nattering
nearing83020333n_earing
neatening1038353neatening
necking143913893n_ecking
needing93214423n_eeding
needling10248753needling
neighing1355523neighing
nerving112910833n_erving
nesting84320443n_esting
nestling958893nestling
nettings9288103n_ettings
nettling957213nettling
niching133612433n_iching
nighing123410063n_ighing
northings13185573northings
noshing114612773n_oshing
notching14288583notching
nothings12266683n_othings
noting74120153n_ot_ing
nudzhing2242033nudzhing
nutting83316233n_utting
panting104025423pant_ing
parching164313053parching
parting103527383part_ing
partying14168893partying
pashing135120513pa_shing
pasting103826553past_ing
patching163212753patching
patting103722343pa_tting
peaching163613643peaching
peching154513903_peching
petting103720953_petting
pithing134014053_pithing
plaything1843853plaything
rafting113815753raft_ing
ralphing1435413ralphing
ranching141712043ranching
ranting84025413rant_ing
rating74938703ra_t_ing
ratting83822363ra_tting
rattling92510873rattling
reaching143317203reaching
retching143412173_retching
rethink1488883_rethink
retting83425883_retting
retying113213833_retying
safetying1643073safetying
salting84120793salt_ing
sashing114621473sa_shing
sating74735453sa_t_ing
sauteing937913sauteing
scathing14269703scathing
scything17264883scything
seating84130683seat_ing
setting83621393_setting
sheathing1636873sheathing
sketching1935083sketching
sleuthing1334203sleuthing
snatching1536363snatching
something1545403something
soothing12269973soothing
southing122811823southing
stetting93410713stetting
swathing15248713swathing
tarting84222653tart_ing
tasting84624213tast_ing
tatting84019523ta_tting
tattling9259473tattling
tauting83316383taut_ing
teaching143612603teaching
teethings1344233teethings
thing96622983___thing
tithing113513893_tithing
toothing12278863toothing
trithing122811773trithing
trothing122410843trothing
tything14316573_tything
unearthing1454373unearthing
unmeshing1595933unmeshing
unsetting1088993unsetting
valeting1238853valet_ing
vatting113614853va_tting
vetoing11309053_vetoing
vetting114216563_vetting
wafting143911663waft_ing
waiting113618953wait_ing
waltzing2134263waltzing
wanting114220173want_ing
washing145119283wa_shing
wasting114422843wast_ing
watching173011173watching
watering122316323watering
wattling12258783wattling
weeting113816053weet_ing
wetting114117383_wetting
whetting1535973whetting
withing143814493_withing
worthing15178053worthing
wrathing15248923wrathing
wreathing16266313wreathing
writhing15278673writhing
xanthin1747043xanthin_
xanthine1847253xanthine
xanthins1846943xanthins
yachting1734933yachting

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 Limit1461622587.47019566.5
3Display Results2582580.0932774.2
 (SQL Overall)1786912587.98622375.5
 
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.