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

472 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
tattings940882(None) 
battings114010571battings
mattings11369671mattings
tatting84019521tatting_
actings104512462_actings
antings85015582_antings
bastings114214692bastings
batting104422272batting_
bittings11339292bittings
castings113614052castings
catlings113712042catlings
catting103922642catting_
cuttings11277612cuttings
eastings93412952eastings
eatings84616432ea_tings
fastings124011942fastings
fatlings12359302fatlings
fatting113818702fatting_
fittings12318202fittings
gatings95212822ga_tings
hatting113920232hatting_
jottings16275192jottings
kartings13418522kartings
lastings94214422lastings
lathings12469852lathings
lattins74115482lattin_s
matings104516202ma_tings
matting103620142matting_
mattins93316142mattin_s
nettings9288102nettings
nuttings9276782nuttings
partings113513732partings
patting103722342patting_
pettings11349702pettings
pittings11349122pittings
ratings84217402ra_tings
ratting83822362ratting_
rattlings10235512rattlings
saltings92811252saltings
settings93810072settings
sittings9339732sittings
slattings10346072slattings
tailings93211672tailings
takings124512562ta_kings
talkings13358402talkings
tannings9268632tannings
tappings13267712tappings
tarting84222652tarting_
tasting84624212tasting_
tatties74120342tatti_es
tattiness9239412tattiness
tattling9259462tattling_
tauting83316382tauting_
tintings9288712tintings
tithings12327692tithings
totting82816842totting_
tuftings12264322tuftings
tutting83515912tutting_
vatting113614852vatting_
waitings123413742waitings
wettings12348402wettings
wittings12328732wittings
ablings1038743_ablings
acting95920983_acting_
actins86321103_actin_s
ageings9437693_ageings
agings86312673_a_gings
airings83913833_airings
anting75827023_anting_
armings103811493_armings
askings12519173_askings
attains7310983attain_s
attaints846493attaints
attends8257593_attends
attics84413283_atti_cs
attires72312953_attires
attunes737823_attunes
audings9289393_audings
awnings11406713_awnings
backings174012213backings
baggings13307523baggings
baiting103918883baiting_
bakings144312013ba_kings
bankings15489403bankings
bantengs1134593bantengs
bantlings12216593bantlings
bashings144311243bashings
basting104227203basting_
bathing134816243bathing_
bating95132253ba_ting_
battens95313263batten_s
battiks1337143batti_ks
battiness11239843battiness
battling113110493battling_
batwing13509813batwing_
beastings12387653beastings
beatings114113223beatings
beltings11369253beltings
betting103921403betting_
bitting103717293bitting_
blastings12347903blastings
blatting114111653blatting_
boatings113710113boatings
bottlings12215293bottlings
buntings11348773buntings
butting103519283butting_
calkings15289223calkings
callings113613833callings
campings154010203campings
cannings113710333cannings
cantinas102713773cantinas
canting104725903canting_
cappings15369493cappings
cardings123812623cardings
carlings114015853carlings
carpings133812383carpings
carting104228283carting_
carvings143810203carvings
casings104013513ca_sings
casting104628343casting_
catjangs1843223catjangs
catkins133012563catkin_s
catling104819793catling_
catlins93818843catlin_s
catmints1236663catmints
catties94023053catti_es
cattiness112310633cattiness
cavings134712543ca_vings
chatting142810143chatting_
coastings12357863coastings
coatings113811843coatings
cutting103817493cutting_
dampings14377523dampings
darings93713643da_rings
darlings103710383darlings
darnings10378553darnings
darting94020663darting_
dating85326483da_ting_
dauting93814763dauting_
dawting123610673dawting_
dotting93314483dotting_
draftings14334203draftings
dratting10389653dratting_
ductings12346673ductings
dustings10419033dustings
eanlings9128473eanlings
earings84517703ea_rings
earnings9419323earnings
earrings9299623earrings
easting84924303easting_
eating75134403ea_ting_
emptings1364813emptings
facings134511263fa_cings
fadings12469303fa_dings
fagotings1443153fagotings
failings123811013failings
fairings12388193fairings
farmings14298213farmings
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_
gratings103910753gratings
gutting93415923gutting_
hafting144014173hafting_
halting114419073halting_
hangings13258583hangings
hanting114124483hanting_
harpings14379773harpings
hasting114725193hasting_
hatchings18225673hatchings
hating104929713ha_ting_
hatpins123410643hatpin_s
hawkings19336133hawkings
hayings14379393ha_yings
hazings20378343ha_zings
hitting113017273hitting_
hotting113116513hotting_
huntings12328053huntings
hustings12378683hustings
hutting113016033hutting_
jestings16368023jestings
jetting153815343jetting_
jotting152912773jotting_
jutting153313713jutting_
karting123716063karting_
katcinas1434513katcinas
kiltings13327083kiltings
kitlings13318103kitlings
kitting123214443kitting_
knittings14273453knittings
knottings14243073knottings
lacings105013653la_cings
ladings93814133la_dings
laggings11298403laggings
lakings124713503la_kings
landings103110073landings
lapwings14274973lapwings
lashings124412253lashings
lasting84725243lasting_
lathing114315693lathing_
latinas74416463la_tinas
latinos73613803la_tinos
latrines8515003latrines
lattens75014673latten_s
lattices1038383lattices
latticings1342843latticings
lattin64316223lattin__
lawings113611473la_wings
letting83218533letting_
listings93310043listings
loathings1344213loathings
lotting82917753lotting_
lutings83311053_lutings
mailings113011923mailings
makings145413153ma_kings
mallings113413093mallings
malting103219083malting_
mantlings12207223mantlings
mappings15296413mappings
markings153410233markings
marlings113713483marlings
marting103325013marting_
martinis103311613martinis
martins93322063martin_s
maskings15448743maskings
masting104325823masting_
mating94832913ma_ting_
matins84527783ma_tin_s
mattin84416633mattin__
mayings134410503ma_yings
meetings11287403meetings
muntings11289813muntings
naethings1343873naethings
nattiness9239333nattiness
netting84018763netting_
nothings12266683nothings
nutting83316233nutting_
outings84014753_outings
outrings92811053outrings
outsings93410333outsings
packings174310063packings
paddings13297003paddings
pagings114411063pa_gings
paintings12327093paintings
pairings11398313pairings
palings103915823pa_lings
panting104025423panting_
pargings123410163pargings
parings104219213pa_rings
parkings153610673parkings
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_
racings105015123ra_cings
rafting113815753rafting_
railings93412153railings
raisings9338443raisings
rankings13389163rankings
ranting84025413ranting_
raspings11337853raspings
ratfinks1542853ratfinks
ratines75328583ra_tines
rating74938703ra_ting_
ratlines83815293ratlines
ratlins73615583ratlin_s
rattans73411953rattan_s
rattens74213403ratten_s
rattling92510873rattling_
rattons73815323ratton_s
ravings114614493ra_vings
retting83425883retting_
rotting82919683rotting_
rutting82718043rutting_
sackings15389633sackings
sacrings11278923sacrings
sailings93513253sailings
saltines82917793saltines
salting84120793salting_
saplings11269803saplings
satangs8479713sa_tangs
sating74735453sa_ting_
satins64930483sa_tin_s
savings114412953sa_vings
sayings113610833sa_yings
scatting113311813scatting_
seatings93614293seatings
setting83621393setting_
settlings1054683settlings
shaftings16224183shaftings
siftings12236583siftings
sitting83519633sitting_
skatings13326993skatings
slatings94011723slatings
slatting94014233slatting_
spatting113111763spatting_
stablings12256103stablings
stagings10378343sta_gings
stalkings14314983stalkings
standings11257153standings
starlings10237923starlings
starting93116173starting_
stating83725163sta_ting_
statins73719773sta_tin_s
stetting93410713stetting_
stings76220183__stings
stotting92811153stotting_
strings84617133_strings
suitings9288953suitings
swatting12309593swatting_
tabbing123611913tabbing_
tabling103216033tabling_
tabuing10308893tabuing_
tacking144421483tacking_
tacklings16235853tacklings
tacrines10310563tacrines
tactics1149323tacti_cs
tactions102912423tactions
tagging103014913tagging_
taglines92210833taglines
tahinis1048003ta_hinis
tailing82923103tailing_
tains54936323ta__in_s
tainting93613583tainting_
taints64520533ta__ints
taking114725953ta_king_
takins105117403ta_kin_s
talcing103111633talcing_
talking123815823talking_
tameins9311413tamein_s
taming94023433ta_ming_
tamping122815813tamping_
tanging93419523tanging_
tangs65028343ta___ngs
tanking123918793tanking_
tankinis12245913tankinis
tanning83618253tanning_
tannins72813223tannin_s
taping94222393ta_ping_
tapping123317133tapping_
taring73932283ta_ring_
tarring83318303tarring_
tartanas8258893tartanas
tartans72615823tartan_s
tartiness92112053tartiness
tasking124616323tasking_
tastiness92311143tastiness
tattering102212323tattering_
tatters74520483tatt_ers
tattie64817513tatti__e
tattier74216243tatti_er
tattiest83415383tattiest
tattily10409993tatti_ly
tattlers8369693tattlers
tattles73616283tatt_les
tattooing1043963tattooing_
tattoos738643tatt_oos
taunting93510933taunting_
taurines8310543taurines
tautaugs9162473tautaugs
tautens7317843tauten_s
tautogs875413taut_ogs
tawing104521553ta_wing_
tawsing1138673tawsing_
taxiing1535723taxiing_
taxing143816713ta_xing_
taxying1836183taxying_
teachings15296553teachings
teethings1344233teethings
tenting84621153tenting_
testing86021053testing_
thatchings1942483thatchings
things104914283__things
tickings15368583tickings
tidings93810253t_idings
tilings84212793t_ilings
tilting83417103tilting_
timings10279303t_imings
tings65329193___tings
tinting84620603tinting_
tithing113513893tithing_
titling83715793titling_
titties73617363titti_es
toasting93410573toasting_
toiting83217093toiting_
tontines82114733tontines
toolings9248473toolings
tooting83019423tooting_
toppings13286423toppings
toting74123793t_oting_
tourings9277373tourings
touting84118453touting_
tracings112910403tracings
trackings16247533trackings
trainings10246723trainings
trappings14265753trappings
trithings13246603trithings
trotting92510913trotting_
tubings10336483t_ubings
tufting11289873tufting_
turnings9287233turnings
turtlings10184873turtlings
tutties73216473tutti_es
tuttis63611373tutti__s
twattling1332693twattling_
twistings13264353twistings
twitting12307223twitting_
tything14316573tything_
vaultings13233633vaultings
vestings12359143vestings
vetting114216563vetting_
waddings14356463waddings
wafting143911663wafting_
waistings1352710763waistings
waiting113618953waiting_
walkings16327313walkings
wanting114220173wanting_
warnings12358453warnings
washings15419273washings
wasting114422843wasting_
waterings13229243waterings
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.1731032896.0
2DLD Change Limit1461624726.70321805.5
3Display Results4724720.1862537.6
 (SQL Overall)1786914727.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.