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

403 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
tannings926863(None) 
cannings113710331cannings
tanning83618251tanning_
tannins72813221tannin_s
antings85015582_antings
awnings11406712_awnings
bankings15489402bankings
banning103818232banning_
canning103620132canning_
cunnings11357342cunnings
darnings10378552darnings
eanlings9128472eanlings
earnings9419332earnings
fanning113615072fanning_
ginnings10366522ginnings
gunnings10346732gunnings
hangings13258582hangings
innings8329442_innings
kennings13315272kennings
landings103110072landings
manning103616382manning_
panning104019392panning_
plannings12325452plannings
rankings13389172rankings
runnings9326912runnings
scannings12264822scannings
standings11257152standings
tailings93211672tailings
takings124512572ta_kings
talkings13358402talkings
tanging93419532tanging_
tanking123918792tanking_
tankinis12245912tankinis
tannin62613932tannin__
tappings13267712tappings
tattings9408822tattings
tinning83117282tinning_
tintings9288712tintings
trainings10246722trainings
tunning83514452tunning_
turnings9287232turnings
twinnings13253662twinnings
vanning113912462vanning_
wanning113816212wanning_
warnings12358452warnings
winnings12327582winnings
ablings1038743_ablings
actings104512463_actings
ageings9437693_ageings
agings86312673_a_gings
airings83913843_airings
anginas8310953_anginas
anglings10228273_anglings
anhinga11104823_anhinga
anhingas12104333_anhingas
annonas738793_annonas
anoints7311063_anoints
anting75827023_anting_
armings103811503_armings
askings12519173_askings
atoning83514873atoning_
audings9289393_audings
awning105013393_awning_
backings174012213backings
baggings13307523baggings
bakings144312023ba_kings
banding114921413banding_
banging114019863banging_
baning95127833ba_ning_
banking144621353banking_
bantengs1134593bantengs
bantlings12216603bantlings
barning104320353barning_
bashings144311243bashings
bastings114214693bastings
battings114010573battings
bindings123810473bindings
binning103615453binning_
bondings12369413bondings
brandings13277483brandings
branning112911093branning_
buntings11348773buntings
burnings11387623burnings
calkings15289223calkings
callings113613833callings
campings154010203campings
canines93724033ca_nines
caning94128623ca_ning_
canniness1138643canniness
cannons94412883cannon_s
cantinas102713783cantinas
canting104725903canting_
canyonings1642873canyonings
cappings15369493cappings
cardings123812643cardings
carlings114015863carlings
carpings133812393carpings
carvings143810213carvings
casings104013513ca_sings
castings113614053castings
catlings113712043catlings
cavings134712543ca_vings
clonings11307433clonings
conning103718753conning_
cunning104214623cunning_
damning114211633damning_
dampings14377523dampings
dancing113611563dancing_
danging103716093danging_
darings93713653da_rings
darlings103710383darlings
darning93817333darning_
dawning124111013dawning_
denning93515173denning_
dinning93416553dinning_
donning93512763donning_
dunning93514473dunning_
eanling81416673eanling_
earings84517713ea_rings
earning83418213earning_
earrings9299633earrings
eastings93412953eastings
eatings84616443ea_tings
endings92910443_endings
evenings1234383evenings
facings134511263fa_cings
fadings12469303fa_dings
failings123811013failings
fairings12388193fairings
fannies103415643fanni_es
fanzines2036913fanzines
farmings14298223farmings
fastings124011943fastings
fatlings12359303fatlings
fawning14409133fawning_
fencings14225663fencings
findings13328443findings
finings114311773_finings
finning113615113finning_
funning113813613funning_
gaining94015663gaining_
gamings114610913ga_mings
ganging103216193ganging_
gaskings14427473gaskings
gassings10438403gassings
gatings95212823ga_tings
gaywings1633193gaywings
ginning93313983ginning_
gnawings13263773gnawings
gunning93413173gunning_
handing123518893handing_
handlings14237343handlings
hanging123518703hanging_
hanking154619103hanking_
hanting114124483hanting_
harpings14379773harpings
hawkings19336133hawkings
hayings14379393ha_yings
hazings20378343ha_zings
hornings12238363hornings
huntings12328053huntings
inning73617633_inning_
ironings9217583ironings
joinings16285243joinings
kartings13418523kartings
kenning124010543kenning_
lacings105013653la_cings
ladings93814133la_dings
laggings11298403laggings
lakings124713513la_kings
lancing103314123lancing_
landing92819323landing_
lapwings14274973lapwings
lashings124412253lashings
lastings94214423lastings
lathings12469853lathings
lawings113611473la_wings
leanings94010183leanings
learnings1094323learnings
linings84313073_linings
loanings9348013loanings
longings10408563longings
mailings113011923mailings
makings145413163ma_kings
mallings113413093mallings
mannans93611523mannan_s
mannites10312613mannites
mantlings12207233mantlings
mappings15296413mappings
markings153410243markings
marlings113713503marlings
maskings15448753maskings
matings104516213ma_tings
mattings11369673mattings
mayings134410513ma_yings
meanings11329163meanings
mendings12338303mendings
minings103912073_minings
mornings11297923mornings
muntings11289813muntings
nandinas936583nandinas
nandins8312003nandin_s
nankins1159053nankin_s
nannies73015203nanni_es
noonings9246653noonings
openings1134803openings
packings174310063packings
paddings13297013paddings
pagings114411063pa_gings
paining103920243paining_
paintings12327093paintings
pairings11398313pairings
palings103915823pa_lings
panelings12107453panelings
panging113319113panging_
panniers10488853panniers
panting104025423panting_
pargings123410163pargings
parings104219213pa_rings
parkings153610683parkings
partings113513733partings
passings11409873passings
pavings134011633pa_vings
pawning134711413pawning_
pennines103112043pennines
penning103616493penning_
pinkings15338143pinkings
pinning103417853pinning_
plankings16326113plankings
planning113610223planning_
plantings12348403plantings
punning103414993punning_
racings105015133ra_cings
railings93412153railings
raining83922693raining_
raisings9338443raisings
ranging94120263ranging_
ranking124320883ranking_
ranting84025413ranting_
raspings11337853raspings
ratings84217413ra_tings
ravenings13235183ravenings
ravings114614503ra_vings
rennins74013413rennin_s
rinning83216743rinning_
rinsings9318013rinsings
running83514593running_
sackings15389633sackings
sacrings11278923sacrings
sailings93513253sailings
saining83621393saining_
saltings92811253saltings
sanding93520603sanding_
sandlings11238093sandlings
saning75127643sa_ning_
saplings11269803saplings
savings114412953sa_vings
sayings113610833sa_yings
scanning113310773scanning_
sinning83918443sinning_
spankings16215003spankings
spanning113311083spanning_
spinnings12294853spinnings
stablings12256103stablings
stagings10378343sta_gings
staining9413373staining_
stalkings14314983stalkings
standing103413633standing_
stanging104013653stanging_
stanines85115673sta_nines
staning83922243sta_ning_
stannites947023stannites
starlings10237923starlings
stunning9298463stunning_
sunning83715673sunning_
swanning12338813swanning_
tabbing123611913tabbing_
tabling103216033tabling_
tabuing10308893tabuing_
tacking144421483tacking_
tacklings16235853tacklings
tacrines10310563tacrines
taenias7311283taeni_as
tagging103014913tagging_
taglines92210833taglines
tahinis1048013ta_hinis
tailing82923103tailing_
tains54936323ta__in_s
tainting93613583tainting_
taints64520533ta__ints
taking114725953ta_king_
takins105117403ta_kin_s
talcing103111633talcing_
talking123815823talking_
tameins9311423tamein_s
taming94023433ta_ming_
tamping122815813tamping_
tangents938713tangents
tanginess10239283tanginess
tangling101712543tangling_
tangoing10177893tangoing_
tangs65028363ta___ngs
tanists7313653ta_nists
tankini11338923tankin_i
tannage8209583tann_age
tannages9228963tannages
tannates81911953tannates
tanners74018393tann_ers
tannic82811483tanni__c
tannish101610573tanni_sh
tannoys1055553tann_oys
tansies74521243tansi_es
taping94222393ta_ping_
tapping123317133tapping_
taring73932283ta_ring_
tarring83318303tarring_
tarting84222653tarting_
tasking124616323tasking_
tasting84624213tasting_
tatting84019523tatting_
taunting93510933taunting_
taurines8310553taurines
tauting83316383tauting_
tawing104521553ta_wing_
tawnies102812503tawni_es
tawniness1245123tawniness
tawsing1138673tawsing_
taxiing1535723taxiing_
taxing143816713ta_xing_
taxying1836183taxying_
teachings15296553teachings
tending94419163tending_
tennies73017973tenni_es
tennis64015303tenni__s
tennises82810133tennises
tennists8297793tennists
tenoning938893tenoning_
tenpins9410073tenpin_s
tensing84616653tensing_
tenting84621153tenting_
thanking16409523thanking_
things104914303t__hings
thinkings17255053thinkings
thinning12319093thinning_
tickings15368583tickings
tidings93810263t_idings
tilings84212793t_ilings
timings10279303t_imings
tinging93619463tinging_
tings65329213t___ings
tining74927543t_ining_
tinklings14224663tinklings
tinniness936093tinniness
tinnitus843783tinnitus
tinting84620603tinting_
tithings12327693tithings
tonging93314513tonging_
tonguings1143223tonguings
toning74025793t_oning_
tontines82114733tontines
toolings9248473toolings
toppings13286423toppings
tourings9277373tourings
tracings112910413tracings
trackings16247543trackings
training93015863training_
trancing112812023trancing_
trannies8415013tranni_es
trappings14265753trappings
trining82919213trining_
tubings10336483t_ubings
tuftings12264323tuftings
tuning74016843t_uning_
tunnelings1142493tunnelings
tunnies73614263tunni_es
turning83713183turning_
twanging13287063twanging_
twining113211443twining_
twinning12367043twinning_
tyning105510413t_yning_
veinings12306433veinings
waddings14356473waddings
waitings123413743waitings
wakenings1743043wakenings
walkings16327313walkings
waning103623803wa_ning_
wanking154216783wanking_
wanting114220173wanting_
warning113717093warning_
washings15419273washings
waxings18366453wa_xings
waxwings2232953waxwings
weanlings1394413weanlings
windings13329973windings
winning113516553winning_
wonning113210793wonning_
yanking154512463yanking_
yarning113512953yarning_
yawning14378343yawning_
yawpings17253583yawpings
yeanlings1393693yeanlings
yearnings1393553yearnings
yenning11369493yenning_

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 Limit1461624036.97020970.2
3Display Results4034030.1562583.3
 (SQL Overall)1786914037.54623680.2
 
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.