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

213 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
walnut93943(None) 
walnuts1033841walnuts
gallnut847252gallnut
walkout1447932walkout
walkup1534192walkup
wallet93327092wallet
walrus956432walrus
want76156172wa_n_t
ablaut8313263ablaut
about75229083_about
abut66834953_a_but
alant55742293_alant
album92312653_album
alert54740663_alert
algum82711763_algum
alist56136783_alist
alit46155693_al_it
allot54933873_allot
almud84012183_almud
almug8429303_almug
aloft8423433_aloft
aloud65018073_aloud
alt36467963_al__t
alum65227613_al_um
annul55813383_annul
ant37270793_a_n_t
anus47131113_a_nus
aunt46553653_aun_t
bailout9414133bailout
ballet84733973ballet
ballot84624093ballot
ballute938543ballute
bannet84925333bannet
barbut104617003barbut
blunt75525023_blunt
callet84536763callet
callus85317073callus
calque17289843calque
cannot83616773cannot
canst74932213ca_nst
cant66362033ca_n_t
caput9823983ca_put
carnet84732873carnet
catgut9310803catgut
clout75330463_clout
cobnut10311323cobnut
daunt65929083daun_t
daut56443563da__ut
donut6324513_donut
faint85837063fain_t
fallout10313503fallout
fanum10313443fa_num
flaunt9712913flaunt
flout86226203_flout
gainst74914703gainst
galiot72322593galiot
gallet73630853gallet
gallnuts943923gallnuts
gallus74313203gallus
galoot72719163galoot
gamut8322983ga_mut
gannet74321853gannet
garnet73928413garnet
gaunt65430403gaun_t
glout65925813_glout
glut56331293_gl_ut
hagbut1278923hagbut
haint85436323hain_t
halest94823273halest
halibut1289053halibut
hallot95426783hallot
hallux1637363hallux
halt76056303hal__t
halutz1868853hal_utz
hant75461593ha_n_t
haunt85229133haun_t
haut75949733ha__ut
hazelnut2042483hazelnut
hognut1039413hognut
jaunt125025273jaun_t
kainit10414483kainit
kalium1239473kalium
kaput11717063ka_put
layout9513703layout
lout45952143__lout
lunt46148843__lunt
magnet9320663magnet
magnum1136733magnum
mahout11415813mahout
mallet84433053mallet
malt66254813mal__t
manat76039993ma_nat
manus75924933ma_nus
maut65448453ma__ut
nut36651963___nut
paint75443693pain_t
palest83926223palest
palet74650803pal_et
pallet84232653pallet
palpus104210283palpus
pant66061263pa_n_t
payout11714653payout
peanut8318183peanut
pignut9311573pignut
planet84228353planet
plant75437113plan_t
qanat144426843qa_nat
ragout7317183ragout
rainout7314393rainout
rant45864683ra_n_t
sacbut10811943sacbut
sagbut959753sagbut
saint55147073sain_t
sallet63734543sallet
salt45758523sal__t
salute64418023sal_ute
sannup836563sannup
slant55238703slan_t
slut45040593_sl_ut
taint55542283tain_t
talcum1036953talcum
talent6323323talent
tallit63422733tallit
taluk94812873tal_uk
talus55423263tal_us
taunt55532283taun_t
taut47048963ta__ut
telnet6518833telnet
umlaut838033umlaut
valet84337873val_et
valgus1047103valgus
valour93010373valour
value85719093val_ue
valuta938743val_uta
vaunt85925313vaun_t
wadset10314303wadset
waeful1238123waeful
waft106139003wa__ft
wailful1344953wailful
wain75840203wain__
wains86930873wain_s
waist86132383wa_ist
wait75553693wa__it
wale74546443wal__e
waled94331003wal_ed
waler84229293wal_er
walers94824493walers
wales86142843wal_es
walies95324523walies
waling104525303waling
walk115625613wal__k
walked145313783walked
walker133914003walker
walkouts1544253walkouts
walks126218503wal_ks
walkups1633013walkups
wall76236103wal__l
walla85321033wal_la
wallah124011993wallah
wallas95719393wallas
walled104021293walled
wallets103914833wallets
wallie93216803wallie
wallop113310293wallop
wallow123913513wallow
walls85529383wal_ls
wally114625093wal_ly
waltz17615473wal_tz
waly105830903wal__y
wammus13426733wammus
wampum15406053wampum
wampus13499013wampus
wamus105514683wa_mus
wan66761943wa_n__
wand85833883wa_n_d
wands96425483wa_nds
wane76344723wa_n_e
waned95831783wa_ned
wanes85040883wa_nes
waney115120323wa_ney
wangun1037113wangun
wank115632513wa_n_k
wanks126124483wa_nks
wanly115118023wa_nly
wanned104318013wanned
wanner94019623wanner
wannest103915003wannest
wans76452273wa_n_s
wants87932213wa_nts
wany106432363wa_n_y
warmup1335353warmup
warn75239323warn__
warned104018913warned
warner93717223warner
warns87231003warn_s
wart77866083wa__rt
washout13410133washout
washup1435323washup
wast75655853wa__st
wat67378923wa___t
watt75545413wa__tt
waucht14399413waucht
waught133811043waught
wauk115220593wa__uk
waul76927313wa__ul
waur76819903wa__ur
welt75547863wel__t
went76051873w_en_t
whatnot1344733whatnot
wilful1235963wilful
willet95124833willet
wilt76246303wil__t
wont75842503w_on_t

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162135.36021029.1
3Display Results2132130.0762802.6
 (SQL Overall)1786912135.81230745.2
 
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.