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

320 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
wallops12341041(None) 
gallops103211651gallops
wallop113310291wallop_
wallows133613531wallows
allods73615082_allods
allots64019172_allots
allows94517682_allows
alloys94014562_alloys
ballons93916962ballons
ballots94116032ballots
callous93516602callous
collops112611752collops
dollops10287962dollops
fallows133713972fallows
gallons83015952gallons
gallop93311382gallop_
gallous82813952gallous
gallows113513512gallows
galops94712622ga_lops
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallows134417392hallows
jalops15329592ja_lops
lollops9227442lollops
mallows123714322mallows
pallors9314362pallors
sallows103915552sallows
saloops93510132saloops
scallops12297392scallops
shallops13288322shallops
swallows14295892swallows
tallols73311362tallols
tallows103313742tallows
walkups1633012walkups
wallahs13409472wallahs
wallas95719392wall_as
wallets103914832wallets
wallies103320742wallies
walloped14146832walloped
walloper13147112walloper
wallopers14136272wallopers
wallow123913512wallo_w
walls85529382wall__s
willows13299752willows
aldols7109713_aldols
algors7312553_algors
allays94313743_allays
allees64521483_allees
alleys95113303_alleys
allies63827673_allies
allod64418383_allo_d
allot54933873_allo_t
allow85420663_allo_w
alloy85519973_allo_y
alls46740923_all__s
allyls9437273_allyls
aloes54933673_a_loes
alps65529243_a_l_ps
altos55822953_alto_s
aslope839013_aslope
azlons154110423_azlons
bailors93212413bailors
balboas113710073balboas
ballads104212913ballads
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballon84117493ballo_n
balloon93711433balloon
balloons103110523balloons
ballot84624093ballo_t
balls76236413ball__s
barhops14288113barhops
barlows12259973barlows
bellhops1544873bellhops
bellows124313303bellows
billons93013363billons
billows123611293billows
bloops106611343_bloops
bullous9311663bullous
callans94518473callans
callas84526753call_as
callboys1585183callboys
callees94117783callees
callers94221963callers
callets93821703callets
calliope1256223calliope
calliopes1346143calliopes
callose9313663callose
calloses10313393calloses
callow114714663callo_w
calls75634733call__s
callus85317073call_us
calos74431903ca_lo_s
caltrops12307863caltrops
carhops14329703carhops
cellos84517803cello_s
clops95924853__clops
collop107312313collop_
cyclops1635383cyclops
dalles74222063dall_es
dallies84023193dallies
daltons8310403daltons
dollop9259363dollop_
earlaps936393earlaps
escallops1343193escallops
falcons1239123falcons
fallals103310193fallals
fallers103917993fallers
falloff1245953falloff
falloffs1343253falloffs
fallout10313503fallout
fallouts1137883fallouts
fallow124713853fallo_w
falls85727653fall__s
felloes104114383felloes
fellows134212433fellows
fillips12298133fillips
fillos94415083fillo_s
flops105920143__flops
follows13409923follows
galiots82311323galiots
galleons9258443galleons
gallets83517403gallets
galleys11369713galleys
gallies84122713gallies
galliots9228683galliots
gallon73715813gallo_n
galloon82910643galloon
galloons9289703galloons
galloot82814223galloot
galloots9268963galloots
galloped12107143galloped
galloper11137183galloper
gallopers12136323gallopers
galls64729323gall__s
gallus74313203gall_us
galoots82410793galoots
galop84716223ga_lop_
glops85619553__glops
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hallo__
halloa94918123hallo_a
halloed113314913halloed
halloo95118973hallo_o
hallot95426783hallo_t
halloth134111253halloth
hallow124818323hallo_w
halls85633783hall__s
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
harlots103413293harlots
helloes103717463helloes
hellos95321683hello_s
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
hilltops1344933hilltops
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
jailors14328753jailors
jalaps15299183ja_laps
jalop144212603ja_lop_
jalopy18325863ja_lopy
jellos134714283jello_s
lallans74113533lallans
lalls55324133lall__s
laptops1166603laptops
lollop8238783lollop_
lollopy12234773lollopy
loops75723963__loops
lops66043353___lops
maillots1037473maillots
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
mallow114014743mallo_w
malls76233433mall__s
maltols939403maltols
maypops16104453maypops
mellows123812233mellows
orlops847303_orlops
pallets93919303pallets
pallor8313673pallo_r
palls74332563pall__s
palmtops1443543palmtops
palps94719563pa_l_ps
parlors9312913parlors
parlous9414293parlous
pillows122610123pillows
plops95920333__plops
pullups1134233pullups
ragtops1035453ragtops
rallies73823343rallies
rallyes10348553rallyes
reallots837993reallots
rollmops1243003rollmops
sailors73213723sailors
saleps85014903sa_leps
sallets73719653sallets
sallies73227813sallies
sallow94315753sallo_w
sallowy13369343sallowy
salmons93713263salmons
salols64017873sa_lols
salons63823693sa_lons
saloons74415323saloons
saloop84212583saloop_
salps74423243sa_l_ps
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salvo_s
sannops936693sannops
sawlogs1135393sawlogs
scallop11237643scallop_
scollops12235703scollops
shallop12348453shallop_
shallots11319503shallots
shallows14388863shallows
slaloms9106543slaloms
sloops85513623_sloops
slops75026013__slops
swallow13355753swallo_w
tailors73212393tailors
talcous939483talcous
talions7314113talions
tallboys1374623tallboys
tallies73624603tallies
tallis63319963tall_is
tallits73215993tallits
tallol63612223tallo_l
tallow93714203tallo_w
tallowy13347633tallowy
talls55133433tall__s
talons64019443ta_lons
thallous1136523thallous
trollops1044813trollops
valleys13407483valleys
valors93413773va_lors
villous102810023villous
wackos155210993wacko_s
wadmols1333913wadmols
waggons1235503waggons
wagons103911213wa_gons
wahoos122310593wa_hoos
wailers103916803wailers
wails86631483wail__s
walers94824463wa_lers
wales86142833wa_l_es
walies95324523wa_lies
walkers143411473walkers
walkout1447933walkout
walkouts1544253walkouts
walks126218503wa_l_ks
walkup1534193walkup_
wall76236103wall___
walla85321033wall__a
wallaby1535073wallaby
wallah124011993wall_ah
wallaroos1244113wallaroos
walled104021293wall_ed
wallet93327093wall_et
walleye1336243walleye
walleyes1435603walleyes
wallie93216803wall_ie
walling113520973walling
walloping1545593walloping
wallopings1652713wallopings
wallowed15148163wallowed
wallower14158933wallower
wallowers15127653wallowers
wally114625093wall__y
walnuts1033843walnuts
walrus956433wa_lrus
waltzes1935953waltzes
wanions104011373wanions
wantons103713013wantons
waps96642083wa___ps
warless104015103warless
warlock1636293warlock
warlocks1735363warlocks
warlord1136293warlord
warlords1245303warlords
warmups1433813warmups
warps107126423wa__rps
washups1534683washups
wasps106714693wa__sps
wataps11248683wa_taps
wauls86120553waul__s
wawls115416473wawl__s
waylays1634673waylays
wayless13308243wayless
wazoos18288553wa_zoos
weblogs1334223weblogs
weldors11238003weldors
wellies103719073wellies
wells85426193well__s
whelps14437843whel_ps
whoops14487863w_hoops
whops135013933w__hops
willers103517913willers
willets104414323willets
willies103920153willies
willow12369693willo_w
willowy16276353willowy
wills84528963will__s
woops104917523w__oops
wops96634153w___ops
yellows13329603yellows

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 Filter1786911340270.440406115.9
2DLD Change Limit1340273206.92019368.1
3Display Results3203200.1102909.1
 (SQL Overall)1786913207.47023921.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.