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

177 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
walnuts103384(None) 
walnut939431walnut_
gallnuts943922gallnuts
walkouts1544252walkouts
walkups1633012walkups
wallets103914832wallets
walrus956432walru_s
wants87932212wa_n_ts
ablauts936083ablauts
abuts75417073_a_buts
alants67722023_alants
albums10198273_albums
alerts64418223_alerts
algums9208043_algums
allots64019173_allots
almuds9378773_almuds
almugs9396423_almugs
alts46639903_al__ts
alums75720603_al_ums
annuls64711733_annuls
ants47243473_a_n_ts
anus47131113_a_nu_s
aunts55227633_aun_ts
bailouts1036613bailouts
ballets93719513ballets
ballots94116033ballots
ballute938543ballute
ballutes1037523ballutes
bannets94013843bannets
barbuts11439843barbuts
blunts84512893_blunts
callets93821703callets
callus85317073callu_s
calques182710193calques
cants77036943ca_n_ts
cantus85117763ca_ntus
carnets93918403carnets
catguts1045323catguts
clouts87017203_clouts
cobnuts1135353cobnuts
daunts75014083daun_ts
dauts67822243da__uts
donuts7410583_donuts
faints94818783fain_ts
fallouts1137883fallouts
fanums1137263fa_nums
flaunts1056133flaunts
flouts94315273_flouts
galiots82311323galiots
gallets83517403gallets
gallnut847253gallnut_
gallus74313203gallu_s
galoots82410793galoots
gamuts958783ga_muts
gannets83811443gannets
garnets84115413garnets
glouts74414713_glouts
gluts66120133_gl_uts
hagbuts1354933hagbuts
haints94417583hain_ts
halibuts1364443halibuts
halitus10339963halitus
halts85230103hal__ts
halutz1868853hal_utz
hants86335403ha_n_ts
haunts95614393haun_ts
hazelnuts2151183hazelnuts
hognuts1134183hognuts
jaunts137511883jaun_ts
kainits1137763kainits
kaliums1336603kaliums
layouts1046483layouts
louts56330273__louts
lunts55826903__lunts
magnets10311143magnets
magnums1234683magnums
mahouts1237143mahouts
mallets93318493mallets
malts76331753mal__ts
manats84623463ma_nats
manus75924933ma_nu_s
mauts75927193ma__uts
nuts45032673___nuts
paints85921833pain_ts
palets85122313pal_ets
pallets93919303pallets
palpus104210283palpu_s
pants76536923pa_n_ts
payouts1247303payouts
peanuts936993peanuts
pignuts1035613pignuts
planets93914083planets
plants84921803plan_ts
qanats154112813qa_nats
ragouts838543ragouts
rainouts846923rainouts
rants55935343ra_n_ts
sacbuts1166473sacbuts
sagbuts1065223sagbuts
saints65122423sain_ts
sallets73719653sallets
salts55431883sal__ts
salute64418023sal_ute
salutes73716253sal_utes
sannups934463sannups
slants64819083slan_ts
sluts54523983_sl_uts
taints64520533tain_ts
talcums1135513talcums
talents7312013talents
tallits73215993tallits
taluks10418283tal_uks
talus55423263tal_u_s
taunts65715663taun_ts
tauts56125513ta__uts
telnets738373telnets
umlauts943193umlauts
valets93715623val_ets
valgus1047103valgu_s
valours10248743valours
values94314943val_ues
valuta938743val_uta
valutas1036533val_utas
vaunts95212623vaun_ts
wadsets1136443wadsets
waeness102512783waeness
wafts116920553wa__fts
wains86930873wain__s
waists97415453wa_ists
waits88333523wa__its
walers94824493wal_ers
wales86142843wal__es
walies95324523wal_ies
walkers143411483walkers
walkout1447933walkout_
walks126218503wal__ks
walkup1534193walku_p
wallahs13409473wallahs
wallas95719393wal_las
wallet93327093wallet_
wallies103320743wallies
wallops123410413wallops
wallows133613533wallows
walls85529383wal__ls
walruses11554973walruses
waltz17615473wal__tz
waltzes1935953waltzes
wammus13426733wammu_s
wampums16314213wampums
wampus13499013wampu_s
wamus105514683wa_mu_s
wands96425483wa_n_ds
wanes85040883wa_n_es
wanguns1135023wanguns
wanks126124483wa_n_ks
wanness102610683wanness
wannest103915003wannest
wans76452273wa_n__s
want76156173wa_n_t_
warmups1433813warmups
warners103315563warners
warns87231003warn__s
warts814840403wa__rts
washouts1445903washouts
washups1534683washups
wasts87433673wa__sts
wats77555883wa___ts
watts86923093wa__tts
wauchts15285283wauchts
waughts14355963waughts
wauks125515163wa__uks
wauls86120553wa__uls
welts85225193wel__ts
whatnots1442303whatnots
willets104414323willets
wilts85023503wil__ts
wonts87621543w_on_ts

Search took 7 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 Filter1786911340270.410435831.7
2DLD Change Limit1340271776.23321502.8
3Display Results1771770.0602950.0
 (SQL Overall)1786911776.70326658.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.