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

486 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
mattings1136967(None) 
battings114010571battings
matings104516211ma_tings
matting103620141matting_
mattins93316141mattin_s
tattings9408821tattings
actings104512462_actings
antings85015582_antings
bastings114214692bastings
batting104422272batting_
bittings11339292bittings
castings113614052castings
catlings113712042catlings
catting103922642catting_
cuttings11277612cuttings
eastings93412952eastings
eatings84616442ea_tings
fastings124011942fastings
fatlings12359302fatlings
fatting113818702fatting_
fittings12318202fittings
gatings95212822ga_tings
hatting113920232hatting_
jottings16275192jottings
kartings13418522kartings
lastings94214422lastings
lathings12469852lathings
lattins74115482lattin_s
mailings113011922mailings
makings145413162ma_kings
mallings113413092mallings
malting103219082malting_
mantlings12207232mantlings
mappings15296412mappings
markings153410242markings
marlings113713492marlings
marting103325012marting_
martinis103311612martinis
martins93322062martin_s
maskings15448752maskings
masting104325822masting_
mating94832912ma_ting_
matins84527782ma_tin_s
mattin84416632mattin__
mayings134410512ma_yings
meetings11287412meetings
muntings11289812muntings
nettings9288102nettings
nuttings9276782nuttings
partings113513732partings
patting103722342patting_
pettings11349702pettings
pittings11349122pittings
ratings84217412ra_tings
ratting83822362ratting_
rattlings10235512rattlings
saltings92811252saltings
settings93810072settings
sittings9339732sittings
slattings10346072slattings
tatting84019522tatting_
vatting113614852vatting_
waitings123413742waitings
wettings12348402wettings
wittings12328732wittings
ablings1038743_ablings
acting95920983_acting_
actins86321103_actin_s
ageings9437693_ageings
agings86312673_a_gings
airings83913843_airings
anting75827023_anting_
armings103811503_armings
askings12519173_askings
attains7310983_attain_s
attaints846493_attaints
attends8257593_attends
attics84413283_atti_cs
attires72312953_attires
attunes737823_attunes
audings9289393_audings
awnings11406713_awnings
backings174012213backings
baggings13307523baggings
baiting103918883baiting_
bakings144312023ba_kings
bankings15489403bankings
bantengs1134593bantengs
bantlings12216603bantlings
bashings144311243bashings
basting104227203basting_
bathing134816243bathing_
bating95132253ba_ting_
battens95313263batten_s
battiks1337143batti_ks
battiness11239843battiness
battling113110493battling_
batwing13509813batwing_
beastings12387653beastings
beatings114113233beatings
beltings11369253beltings
betting103921403betting_
bitting103717293bitting_
blastings12347913blastings
blatting114111653blatting_
boatings113710113boatings
bottlings12215293bottlings
buntings11348773buntings
butting103519283butting_
calkings15289223calkings
callings113613833callings
campings154010203campings
cannings113710333cannings
cantinas102713773cantinas
canting104725903canting_
cappings15369493cappings
cardings123812633cardings
carlings114015853carlings
carpings133812383carpings
carting104228283carting_
carvings143810203carvings
casings104013513ca_sings
casting104628343casting_
catjangs1843223catjangs
catkins133012563catkin_s
catling104819793catling_
catlins93818843catlin_s
catmints1236663catmints
catties94023053catti_es
cattiness112310633cattiness
cavings134712543ca_vings
chatting142810143chatting_
coastings12357863coastings
coatings113811843coatings
cutting103817493cutting_
dampings14377523dampings
darings93713653da_rings
darlings103710383darlings
darnings10378553darnings
darting94020663darting_
dating85326483da_ting_
dauting93814763dauting_
dawting123610673dawting_
dotting93314483dotting_
draftings14334203draftings
dratting10389653dratting_
ductings12346673ductings
dustings10419033dustings
eanlings9128473eanlings
earings84517713ea_rings
earnings9419333earnings
earrings9299633earrings
easting84924303easting_
eating75134403ea_ting_
emitting112410353emitting_
emptings1364823emptings
facings134511263fa_cings
fadings12469303fa_dings
fagotings1443153fagotings
failings123811013failings
fairings12388193fairings
farmings14298223farmings
farthings1635233farthings
farting114120753farting_
fasting114522833fasting_
fating105328673fa_ting_
fatling113815683fatling_
fattens105111713fatten_s
fatties103018203fatti_es
fattiness12239373fattiness
feltings12317903feltings
fetting113517873fetting_
fettlings1353753fettlings
fitting113516563fitting_
flatlings13315823flatlings
flatting123511253flatting_
flutings12357373flutings
flytings15304793flytings
footings12248833footings
gaiting93716583gaiting_
gamings114610913ga_mings
gaskings14427473gaskings
gassings10438403gassings
gasting95022763gasting_
gating84826953ga_ting_
gaywings1633193gaywings
getting93316563getting_
gitting93215703gitting_
gratings103910763gratings
gutting93415923gutting_
hafting144014173hafting_
halting114419073halting_
hangings13258583hangings
hanting114124483hanting_
harpings14379773harpings
hasting114725193hasting_
hatchings18225673hatchings
hating104929713ha_ting_
hatpins123410643hatpin_s
hawkings19336133hawkings
hayings14379393ha_yings
hazings20378343ha_zings
hitting113017273hitting_
hotting113116523hotting_
huntings12328053huntings
hustings12378683hustings
hutting113016033hutting_
imagings1234553ima_gings
jestings16368023jestings
jetting153815343jetting_
jotting152912773jotting_
jutting153313713jutting_
karting123716063karting_
katcinas1434513katcinas
kiltings13327083kiltings
kitlings13318103kitlings
kitting123214443kitting_
knittings14273453knittings
knottings14243073knottings
lacings105013653la_cings
ladings93814133la_dings
laggings11298403laggings
lakings124713513la_kings
landings103110073landings
lapwings14274973lapwings
lashings124412253lashings
lasting84725243lasting_
lathing114315693lathing_
latinas74416463la_tinas
latinos73613803la_tinos
latrines8515003latrines
lattens75014673latten_s
lattices1038383lattices
latticings1342843latticings
lattin64316223lattin__
lawings113611473la_wings
letting83218533letting_
listings93310043listings
loathings1344213loathings
lotting82917753lotting_
lutings83311053_lutings
machines15312893machines
macing114221553ma_cing_
madding123711993madding_
maftirs1236043mafti_rs
mahjongs2141813mahjongs
mahuangs1452883mahuangs
mailing102923343mailing_
maiming122912723maiming_
mains75635113ma__in_s
making134823853ma_king_
maligns1038133ma_ligns
malines93625603ma_lines
malkins133311803malkin_s
malling103623663malling_
maltiness112910573maltiness
manning103616383manning_
mantids103113623manti_ds
mantis83926033manti__s
mantises10317923mantises
mantling112012613mantling_
mapping143413993mapping_
marblings14225543marblings
margins103815193margin_s
marinas93519383ma_rinas
marines93928013ma_rines
marketings1743163marketings
marking144020133marking_
marlines103818713marlines
marling103322763marling_
marlins93420473marlin_s
marring103319553marring_
martens93714953marten_s
martians103111613martians
martin84122523martin__
martinet10319643martinet
martinets1138883martinets
martingal1244063martingal
martingals1343313martingals
martini93613873martin_i
mashing134422243mashing_
masking145116613masking_
massing104318023massing_
mastics112614783masti_cs
mastiffs1644233mastiffs
mastitis1039103mastitis
mastixes1738253mastixes
matching163512393matching_
matin75132853ma_tin__
matinal9312603ma_tinal
matinee92415613ma_tinee
matinees102110423ma_tinees
matiness102114753ma_tiness
matrices12312083matrices
matrixes1738063matrixes
matrons93517633matron_s
mattering122314053mattering_
matters94421753matt_ers
mattes85624533matt__es
mattocks1644983mattocks
mattoids1196183mattoids
mattrass1045863mattrass
mattress1036533mattress
matts76829183matt___s
maturing1139953maturing_
matutinal1143183matutinal
mauling103315683mauling_
mavins115119183ma_vin_s
mawing124020803ma_wing_
maxing164817073ma_xing_
maying124421153ma_ying_
mayvins1535323mayvin_s
mazing184418973ma_zing_
meanings11329163meanings
meeting103314963meeting_
melting103317753melting_
mendings12338303mendings
mestinos1048163mestinos
methinks1775193methinks
meting94320593m_eting_
metring103215293metring_
millings113712583millings
milting103619123milting_
minings103912073m_inings
minting103020813minting_
misting103623383misting_
mitring103514143mitring_
mittens9349883mitten_s
mittimus1243023mittimus
moating104218153moating_
moldings12267203moldings
molting103517173molting_
moorings11257713moorings
mooting103019363mooting_
mornings11297923mornings
moshings14367333moshings
motorings1245973motorings
mottling11197753mottling_
mountings12266163mountings
mousings11277703mousings
mowings13328483m_owings
muggings13244593muggings
munting103718773munting_
muntins92715133muntin_s
musings10389543m_usings
mustangs11255973mustangs
musting103221073musting_
mutating112211753mutating_
mutines93117823m_utines
muting93921523m_uting_
muttons949283mutton_s
naethings1343873naethings
nattiness9239333nattiness
netting84018763netting_
nothings12266683nothings
nutting83316233nutting_
omitting11217743omitting_
outings84014753_outings
outrings92811053outrings
outsings93410333outsings
packings174310063packings
paddings13297013paddings
pagings114411063pa_gings
paintings12327093paintings
pairings11398313pairings
palings103915823pa_lings
panting104025423panting_
pargings123410163pargings
parings104219213pa_rings
parkings153610683parkings
parting103527383parting_
passings11409873passings
pastinas103712153pastinas
pasting103826553pasting_
patinas96318523pa_tinas
patines95225763pa_tines
patins87528783pa_tin_s
pattens95414923patten_s
patties93425143patti_es
pavings134011633pa_vings
petting103720953petting_
pitting103618873pitting_
plaitings12296243plaitings
plantings12348403plantings
platings113611363platings
platting114813033platting_
postings112912303postings
potting103720893potting_
putting103218573putting_
racings105015133ra_cings
rafting113815753rafting_
railings93412153railings
raisings9338443raisings
rankings13389173rankings
ranting84025413ranting_
raspings11337853raspings
ratfinks1542853ratfinks
ratines75328583ra_tines
rating74938703ra_ting_
ratlines83815293ratlines
ratlins73615583ratlin_s
rattans73411953rattan_s
rattens74213403ratten_s
rattling92510873rattling_
rattons73815323ratton_s
ravings114614503ra_vings
retting83425883retting_
rotting82919683rotting_
rutting82718043rutting_
sackings15389633sackings
sacrings11278923sacrings
sailings93513253sailings
saltines82917793saltines
salting84120793salting_
saplings11269803saplings
satangs8479713sa_tangs
sating74735453sa_ting_
satins64930483sa_tin_s
savings114412953sa_vings
sayings113610833sa_yings
scatting113311813scatting_
seatings93614303seatings
setting83621393setting_
settlings1054683settlings
shaftings16224183shaftings
siftings12236583siftings
sitting83519633sitting_
skatings13326993skatings
slatings94011723slatings
slatting94014233slatting_
smaltines1136993smaltines
smarting113212453smarting_
smatterings14103843smatterings
smutting11278063smutting_
spatting113111763spatting_
stagings10378343stagings
stating83725163stating_
statins73719773statin_s
stings76220183__stings
strings84617133_strings
suitings9288953suitings
swatting12309593swatting_
tailings93211673tailings
takings124512573ta_kings
talkings13358403talkings
tannings9268633tannings
tappings13267713tappings
tarting84222653tarting_
tasting84624213tasting_
tatties74120343tatti_es
tattiness9239413tattiness
tattling9259473tattling_
tauting83316383tauting_
things104914303__things
tings65329203___tings
tintings9288713tintings
tithings12327693tithings
totting82816843totting_
tuftings12264323tuftings
tutting83515913tutting_
vaultings13233633vaultings
vestings12359143vestings
vetting114216563vetting_
waddings14356473waddings
wafting143911663wafting_
waistings1352710763waistings
waiting113618953waiting_
walkings16327313walkings
wanting114220173wanting_
warnings12358453warnings
washings15419273washings
wasting114422843wasting_
waterings13229253waterings
wattling12258783wattling_
waxings18366453wa_xings
waxwings2232953waxwings
weltings12388203weltings
westings12429803westings
wetting114117383wetting_
whitings15287063whitings
witlings12328443witlings
witting113417063witting_
wotting112913843wotting_
writings12298113writings
yachtings1842663yachtings
yawpings17253583yawpings

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.1531167915.0
2DLD Change Limit1461624866.95621012.4
3Display Results4864860.2002430.0
 (SQL Overall)1786914867.30924448.1
 
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.