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

121 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
swallows1429589(None) 
sallows103915551s_allows
shallows14388861shallows
swallow13355751swallow_
wallows133613531_wallows
allows94517682__allows
fallows133713972_fallows
gallows113513512_gallows
hallows134417392_hallows
mallows123714322_mallows
reswallows1661212reswallows
sallow94315752s_allow_
sallowy13369342s_allowy
scallops12297392scallops
shallops13288322shallops
shallots11319502shallots
shallow13388872shallow_
swallowed1663582swallowed
swallower1554332swallower
swallowers1653812swallowers
tallows103313742_tallows
wallops123410412_wallops
wallow123913512_wallow_
willows13299752_willows
allods73615083__allods
allots64019173__allots
allow85420663__allow_
alloys94014563__alloys
ballons93916963_ballons
ballots94116033_ballots
barlows12259973_barlows
bellows124313303_bellows
billows123611293_billows
callous93516603_callous
callow114714663_callow_
disallows1343393disallows
escallops1343193escallops
fallow124713853_fallow_
fellows134212433_fellows
follows13409923_follows
gallons83015953_gallons
gallops103211653_gallops
gallous82813953_gallous
halloas104318463_halloas
halloes104021523_halloes
halloos103716743_halloos
hallos95425103_hallo_s
hallow124818323_hallow_
hollows134412333_hollows
mallow114014743_mallow_
mellows123812233_mellows
pallors9314363_pallors
pillows122610123_pillows
reallots837993reallots
reswallow1561423reswallow_
sailors73213723s_ailors
salchows1644203s_alchows
sallets73719653s_allets
sallies73227813s_allies
sallowed12149033s_allowed
sallower11139503s_allower
sallowest1246563s_allowest
sallowish1544943s_allowish
sallowly14344833s_allowly
salmons93713263s_almons
salols64017873s_a_lols
salons63823693s_a_lons
saloons74415323s_aloons
saloops93510133s_aloops
salvoes102811313s_alvoes
salvors103910913s_alvors
salvos94613383s_alvo_s
sawlogs1135393s_awlogs
scallions1145783scallions
scallop11237643scallo_p
scalls84218203scall__s
scollops12235703scollops
shadblows1842473shadblows
shadows1437193sha_dows
shalloon1145683shalloon
shalloons1245223shalloons
shallop12348453shallo_p
shallot103614133shallo_t
shallowed1655083shallowed
shallower1555673shallower
shallowest1643993shallowest
shallowly1842613shallowly
shaloms1288983sha_loms
slaloms9106543sla_loms
slows85323463s___lows
smalls84514123small__s
smaltos9408193smalto_s
spallers102910733spallers
spalls84217343spall__s
sparrows1344803sparrows
stallions946073stallions
stalls64019933stall__s
sunglows1244083sunglows
swails94913123swail__s
swales93920763swa_l_es
swallowing1743043swallowing
swells93913983swell__s
swillers11299113swillers
swills94213363swill__s
tallols73311363_tallols
tallow93714203_tallow_
tallowy13347633_tallowy
thallous1136523thallous
unhallows15122123unhallows
wallahs13409473_wallahs
wallas95719393_wall_as
wallets103914833_wallets
wallies103320743_wallies
wallop113310293_wallo_p
wallowed15148163_wallowed
wallower14158933_wallower
wallowers15127653_wallowers
walls85529383_wall__s
willow12369693_willow_
willowy16276353_willowy
yellows13329603_yellows

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621216.50022486.5
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.95225703.5
 
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.