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

157 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
wallower1415893(None) 
callower13159071callower
hallower14139811hallower
sallower11139501sallower
swallower1554331swallower
walloper13147111walloper
wallowed15148161wallowed
wallowers15127651wallowers
willower14127451willower
allover1038582_allover
allowed111610082_allowed
balloter1078892balloter
bellower13159062bellower
fallowed15127752fallowed
follower14137072follower
galloper11137182galloper
hallowed15179492hallowed
hallowers15137722hallowers
hollower14127392hollower
mellower13167402mellower
sallowed12149032sallowed
shallower1555672shallower
swallowed1663582swallowed
swallowers1653812swallowers
tallowed12157712tallowed
walkover1842942walkover
wallflower1952532wallflower
walloped14146832walloped
wallopers14136272wallopers
wallow123913512wallow__
wallows133613532wallow_s
warpower1645042warpower
willowed15156762willowed
willowers15166692willowers
willowier1563782willowier
willpower1773182willpower
yellower14186212yellower
allayer10148213_allayer
alleger8319633_alleger
allobar946663_allobar
allotter866473_allotter
allovers1137673_allovers
allow85420663_allow__
allows94517683_allow_s
alloyed11158033_alloyed
allurer7348433_allurer
almoner949383_almoner
avower1236823_a_vower
baller83825203ball__er
ballonet10314503ballonet
balloted1189043balloted
balloters1157673balloters
ballsier1036523ballsier
beflower16166273beflower
bellowed14158603bellowed
bellowers14177623bellowers
billowed14137063billowed
billowier1444293billowier
blower115316573__blower
caller85125483call__er
calliper1247513calliper
callose9313663callose_
calloses10313393calloses
callow114714663callow__
callowest1445823callowest
caloyer1238143ca_loyer
dallier84215373dall_ier
dayflower1942543dayflower
deflower15126073deflower
falconer1346033falconer
faller94621233fall__er
fallow124713853fallow__
fallows133713973fallow_s
fellowed15136833fellowed
flower124815503__flower
followed15146273followed
followers15146183followers
galloped12107143galloped
gallopers12136323gallopers
gallows113513513gallow_s
gallowses1374943gallowses
glower105114933__glower
halloaed121510153halloaed
halloed113314913hallo_ed
halloes104021523hallo_es
hallooed12168773hallooed
hallow124818323hallow__
hallows134417393hallow_s
harrower1446363harrower
hollowed15157023hollowed
lower85830413___lower
mallow114014743mallow__
mallows123714323mallow_s
manpower1544703manpower
mayflower2042723mayflower
mellowed14166923mellowed
narrower1145063narrower
pallier94417163pall_ier
pallor8313673pallo__r
pillowed14156383pillowed
plower114315063__plower
pullover13134643pullover
rallier73816273rall_ier
reflower14126843reflower
rollover1144453rollover
safflower1842993safflower
sallier73320423sall_ier
sallow94315753sallow__
sallowest1246563sallowest
sallowly14344833sallowly
sallows103915553sallow_s
sallowy13369343sallow_y
scalloper1344453scalloper
shallowed1655083shallowed
slalomer1045033slalomer
slower94016153__slower
swallow13355753swallow__
swallows14295893swallow_s
taller63721963tall__er
tallier72817213tall_ier
tallow93714203tallow__
tallows103313743tallow_s
tallowy13347633tallow_y
unallowed1344413unallowed
waggoner1343423waggoner
wagoner1136093wa_goner
wailer93720323wail__er
waler84229263wa_l__er
walker133913993wa_l_ker
walkovers1942613walkovers
walled104021293wall__ed
wallet93327093wall__et
walleye1336243walleye_
walleyed1534153walleyed
walleyes1435603walleyes
wallflowers2052403wallflowers
wallie93216803wall_ie_
wallies103320743wall_ies
wallop113310293wallo__p
wallops123410413wallo_ps
wallowing1666073wallowing
wallpaper1642803wallpaper
waltzer1934383wa_ltzer
wantoner1187563wantoner
warpowers1744553warpowers
waylayer1743153waylayer
welcomer1544023welcomer
welldoer1243473welldoer
widower1435343w_idower
wildflower20112743wildflower
willer94021063will__er
willow12369693willow__
willows13299753willow_s
willowy16276353willow_y
willpowers1842893willpowers
winnower1444253winnower
yellowed15185743yellowed

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.843211970.3
2DLD Change Limit1461621577.72018932.9
3Display Results1571570.0602616.7
 (SQL Overall)1786911578.62320722.6
 
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.