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

151 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
scallops1229739(None) 
escallops1343191escallops
scallop11237641scallop_
scollops12235701scollops
shallops13288321shallops
callous93516602_callous
collops112611752_collops
escallop1243192escallop_
escalops1244672esca_lops
gallops103211652_gallops
sallows103915552s_allows
saloops93510132s_aloops
scaleups1243392scaleups
scallions1145782scallions
scalloped1444462scalloped
scalloper1344452scalloper
scallopers1454042scallopers
scalls84218202scall__s
scalps104315232sca_l_ps
scollop11275432scollop_
shallop12348452shallop_
shallots11319502shallots
shallows14388862shallows
swallows14295892swallows
wallops123410412_wallops
acaulous1045923acaulous
allods73615083__allods
allots64019173__allots
allows94517683__allows
alloys94014563__alloys
ballons93916963_ballons
ballots94116033_ballots
callans94518473_callans
callas84526753_call_as
callboys1585183_callboys
callees94117783_callees
callers94221963_callers
callets93821703_callets
calliope1256223_calliope
calliopes1346143_calliopes
callose9313663_callose
calloses10313393_calloses
callow114714663_callo_w
calls75634733_call__s
callus85317073_call_us
calos74431903_ca_lo_s
caltrops12307863_caltrops
carhops14329703_carhops
cellos84517803_cello_s
clops95924853_c__lops
collop107312313_collop_
cyclops1635383_cyclops
dollops10287963_dollops
escalloped1542593escalloped
escalop1144783esca_lop_
escalope1244523esca_lope
escalopes1344773esca_lopes
fallows133713973_fallows
gallons83015953_gallons
gallop93311383_gallop_
gallous82813953_gallous
gallows113513513_gallows
galops94712623_ga_lops
halloas104318463_halloas
halloes104021523_halloes
halloos103716743_halloos
hallos95425103_hallo_s
hallows134417393_hallows
jalops15329593_ja_lops
lollops9227443_lollops
mallows123714323_mallows
pallors9314363_pallors
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
scabious1246593scabious
scabrous1245993scabrous
scalades11258803scalades
scalados11276083scalados
scalages113010253scalages
scalares103210983scalares
scalars93711903sca_lars
scalds94813693sca_l_ds
scaleless1135513scaleless
scalenus1045543scalenus
scalers93817263sca_lers
scales84529313sca_l_es
scaleup1134483scaleup_
scall74420373scall___
scallion1046793scallion
scalloping1543953scalloping
scallopini1452783scallopini
scallopinis1551843scallopinis
scalp95217983sca_l_p_
scalpels12345883scalpels
scalpers123710863scalpers
scamps125014173sca__mps
scarious10610203scarious
scarless10189053scarless
scarlets10178573scarlets
scarps104718603sca__rps
scaups105411933sca__ups
schlepps1762563schlepps
schleps1445483sc_hleps
schlumps1742743schlumps
scillas9310473scill_as
scolloped1443653scolloped
scoops105414363sc__oops
scops95820193sc___ops
scroops11288253sc_roops
scullers103510483scullers
scullions1154683scullions
sculls84613883scull__s
sculps104611753sc_ul_ps
shalloon1145683shalloon
shalloons1245223shalloons
shallot103614133shallo_t
shallow13388873shallo_w
shaloms1288983sha_loms
slaloms9106543sla_loms
sloops85513623s__loops
slops75026013s___lops
smallpox1941843smallpox
smalls84514123small__s
smaltos9408193smalto_s
spallers102910733spallers
spalls84217343spall__s
stallions946073stallions
stalls64019933stall__s
swallow13355753swallo_w
tallols73311363_tallols
tallows103313743_tallows
thallous1136523thallous
trollops1044813trollops
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.420425454.8
2DLD Change Limit1461621516.72021750.3
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.20324807.9
 
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.