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

183 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
wallowed1514816(None) 
allowed111610071_allowed
fallowed15127751fallowed
hallowed15179491hallowed
sallowed12149031sallowed
swallowed1663581swallowed
tallowed12157711tallowed
walloped14146831walloped
wallower14158931wallower
willowed15156761willowed
alloyed11158032_alloyed
balloted1189042balloted
bellowed14158602bellowed
billowed14137062billowed
callower13159072callower
fellowed15136832fellowed
followed15146272followed
galloped12107142galloped
halloaed121510152halloaed
halloed113314912hallo_ed
hallooed12168772hallooed
hallower14139812hallower
hollowed15157022hollowed
mellowed14166922mellowed
pillowed14156382pillowed
sallower11139502sallower
shallowed1655082shallowed
swallower1554332swallower
unallowed1344412unallowed
walled104021292wall__ed
walleyed1534152walleyed
walloper13147112walloper
wallow123913512wallow__
wallowers15127652wallowers
wallows133613532wallow_s
willower14127452willower
yellowed15185742yellowed
alcoved1375613_alcoved
allayed11138063_allayed
alleged9389313_alleged
allied74217153_all_ied
allod64418373_allo__d
allotted986873_allotted
allover1038583_allover
allow85420663_allow__
allowedly1642303_allowedly
allows94517683_allow_s
allseed835953_allseed
alluded9327093_alluded
allured8299173_allured
arrowed1148103_arrowed
avowed1335953_a_vowed
balled94926893ball__ed
ballonet10314503ballonet
ballooned1245103ballooned
balloter1078893balloter
bellower13159063bellower
blowed125016693__blowed
bolloxed1834473bolloxed
called94126733call__ed
callose9313663callose_
calloses10313393calloses
calloused1244403calloused
callow114714663callow__
callowest1445823callowest
callused1135853callused
dallied93713603dall_ied
disallowed1543263disallowed
dolloped1234983dolloped
elbowed13235473_elbowed
fallow124713853fallow__
fallows133713973fallow_s
farrowed1545283farrowed
flowed133513763__flowed
follower14137073follower
galled84622853gall__ed
galleted1038213galleted
gallied94114993gall_ied
gallooned1144463gallooned
galloper11137183galloper
gallows113513513gallow_s
gallowses1374943gallowses
gallused1034193gallused
galoped11138063ga_loped
glowed114913833__glowed
halloes104021523hallo_es
hallow124818323hallow__
hallowers15137723hallowers
hallows134417393hallow_s
haloed104717593ha_lo_ed
harrowed1556263harrowed
helloed113512423hello_ed
hilloaed12136923hilloaed
hilloed113211293hillo_ed
holloaed12157393holloaed
holloed113812753hollo_ed
hollooed12146493hollooed
hollower14127393hollower
hulloaed12105803hulloaed
hulloed11369793hullo_ed
hullooed12135093hullooed
lalled74218753lall__ed
lolloped1134463lolloped
lowed95233903___lowed
malled94626103mall__ed
mallow114014743mallow__
mallows123714323mallow_s
malposed1344563malposed
marrowed1445973marrowed
mellower13167403mellower
narrowed1235203narrowed
palled94625163pall__ed
palleted1139863palleted
plowed124213203__plowed
rallied83514083rall_ied
reflowed15126903reflowed
reglowed13125853reglowed
replowed14127563replowed
reswallowed1851143reswallowed
sallied83316953sall_ied
sallow94315753sallow__
sallowest1246563sallowest
sallowly14344833sallowly
sallows103915543sallow_s
sallowy13369343sallow_y
salvoed11307063salvo_ed
scalloped1444463scalloped
shallower1555673shallower
slalomed1134283slalomed
slowed104617073__slowed
swallow13355753swallow__
swallowers1653813swallowers
swallows14295883swallow_s
tailored936203tailored
tallaged10257923tallaged
tallied83314753tall_ied
tallow93714203tallow__
tallows103313733tallow_s
tallowy13347633tallow_y
taloned8310223ta_loned
unalloyed1343723unalloyed
unhallowed1742193unhallowed
unplowed1436353unplowed
upflowed1742893upflowed
valleyed1534013valleyed
waggoned1443253waggoned
wagoned1256223wa_goned
wailed104823593wail__ed
waled94330993wa_l__ed
walked145313783wa_l_ked
walkover1842943walkover
wallboard1545023wallboard
wallet93327093wall__et
walleye1336243walleye_
walleyes1435603walleyes
wallflower1952533wallflower
wallie93216803wall_ie_
wallies103320743wall_ies
wallop113310293wallo__p
wallopers14136273wallopers
wallops123410413wallo_ps
wallowing1666073wallowing
waltzed2033493wa_ltzed
wantoned12117223wantoned
warlord1136293warlo_rd
warpower1645043warpower
wauled104713963waul__ed
wawled133811703wawl__ed
welcomed1643323welcomed
welled103820213well__ed
widowed1534843w_idowed
willed104722453will__ed
willied114611563will_ied
willow12369693willow__
willowers15166693willowers
willowier1563783willowier
willows13299743willow_s
willowy16276353willow_y
willpower1773183willpower
windowed1635573windowed
winnowed1543463winnowed
wowed124023773w___owed
yellower14186213yellower

Search took 9 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.1701051123.5
2DLD Change Limit1461621838.39317414.8
3Display Results1831830.1401307.1
 (SQL Overall)1786911838.70320532.1
 
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.