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

164 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
shallops1328832(None) 
scallops12297391scallops
shallop12348451shallop_
shallots11319501shallots
shallows14388861shallows
escallops1343192escallops
gallops103211652_gallops
halloas104318462_halloas
halloes104021522_halloes
halloos103716742_halloos
hallos95425102_hallo_s
hallows134417392_hallows
sallows103915552s_allows
saloops93510132s_aloops
scallop11237642scallop_
scollops12235702scollops
shalloon1145682shalloon
shalloons1245222shalloons
shallot103614132shallo_t
shallow13388872shallo_w
shaloms1288982sha_loms
swallows14295892swallows
thallous1136522thallous
wallops123410412_wallops
allods73615083__allods
allots64019173__allots
allows94517683__allows
alloys94014563__alloys
ballons93916963_ballons
ballots94116033_ballots
callous93516603_callous
challahs16377563challahs
challas124414123chall_as
challies133915643challies
challis124613463chall_is
challot123613263challo_t
challoth16316103challoth
collops112611753_collops
dollops10287963_dollops
escallop1243193escallop_
escalops1244673esca_lops
fallows133713973_fallows
gallons83015953_gallons
gallop93311383_gallop_
gallous82813953_gallous
gallows113513513_gallows
galops94712623_ga_lops
hallahs133912463_hallahs
hallels103310133_hallels
hallo85127553_hallo__
halloa94918123_hallo_a
halloed113314913_halloed
halloo95118973_hallo_o
hallot95426783_hallo_t
halloth134111253_halloth
hallow124818323_hallo_w
halls85633783_hall__s
haloes94623863_ha_loes
halons95720713_ha_lons
halos85230253_ha_lo_s
harlots103413293_harlots
helloes103717463_helloes
hellos95321683_hello_s
hilloas104413553_hilloas
hilloes103815963_hilloes
hillos94618893_hillo_s
hilltops1344933_hilltops
holloas103814943_holloas
holloes103818193_holloes
holloos104013583_holloos
hollos95320633_hollo_s
hollows134412333_hollows
hulloas103911913_hulloas
hulloes104113923_hulloes
hulloos104010073_hulloos
hullos94916293_hullo_s
jalops15329593_ja_lops
lollops9227443_lollops
mallows123714323_mallows
pallors9314363_pallors
phallus1236063phall_us
phyllos1535583phyllo_s
reallots837993reallots
sailors73213723s_ailors
saleps85014903s_a_leps
sallets73719653s_allets
sallies73227813s_allies
sallow94315753s_allo_w
sallowy13369343s_allowy
salmons93713263s_almons
salols64017873s_a_lols
salons63823693s_a_lons
saloons74415323s_aloons
saloop84212583s_aloop_
salps74423243s_a_l_ps
salvoes102811313s_alvoes
salvors103910913s_alvors
salvos94613383s_alvo_s
sannops936693s_annops
sawlogs1135393s_awlogs
scaleups1243393scaleups
scallions1145783scallions
scalloped1444463scalloped
scalloper1344453scalloper
scallopers1454043scallopers
scalls84218203scall__s
scalps104315233sca_l_ps
scollop11275433scollop_
shackoes17367853shackoes
shackos16429023shacko_s
shadblows1842473shadblows
shadoofs1554233shadoofs
shadows1437193sha_dows
shahdoms1743773shahdoms
shakeups1742373shakeups
shakoes144510023sha_koes
shakos134912193sha_ko_s
shales94731253sha_l_es
shall85024053shall___
shallowed1655083shallowed
shallower1555673shallower
shallowest1643993shallowest
shallowly1842613shallowly
shalom11810923sha_lo_m
shammos14307203shammo_s
shamois123210423sha_mois
shamos114216983sha_mo_s
shamoys15367283sha_moys
shampoos1544603shampoos
shapeups1542723shapeups
sharps115516083sha__rps
shasliks1544143shasliks
shauls94913113shaul__s
shawls125411973shawl__s
shellacs1345573shellacs
shellers112812573shellers
shells94319523shell__s
shills94519613shill__s
shiplaps1544363shiplaps
shlepps14394833sh_lepps
shleps114710333sh__leps
shlumps1434143sh_lumps
sholoms1278033sh_oloms
shops104222903sh___ops
slaloms9106543sla_loms
sloops85513623s__loops
slops75026013s___lops
smallpox1941843smallpox
smalls84514123small__s
smaltos9408193smalto_s
spallers102910733spallers
spalls84217343spall__s
stallions946073stallions
stalls64019933stall__s
swallow13355753swallo_w
tallols73311363_tallols
tallows103313743_tallows
thallious1243273thallious
thalloid1246283thalloid
thallus1035603thall_us
trollops1044813trollops
unhallows15122123unhallows
wallop113310293_wallop_
wallows133613533_wallows

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621646.76621602.4
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.23224708.4
 
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.