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

194 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
shallop1234845(None) 
scallop11237641scallop
shallops13288311shallops
shallot103614131shallot
shallow13388871shallow
challot123613262challot
escallop1243182escallop
gallop93311382_gallop
hallo85127552_hallo_
halloa94918122_halloa
halloo95118972_halloo
hallos95425102_hallos
hallot95426782_hallot
hallow124818322_hallow
sallow94315752s_allow
saloop84212582s_aloop
scallops12297372scallops
scollop11275432scollop
shall85024052shall__
shalloon1145672shalloon
shallots11319492shallots
shallows14388852shallows
shalom11810912sha_lom
swallow13355752swallow
wallop113310292_wallop
allod64418373__allod
allot54933873__allot
allow85420663__allow
alloy85519973__alloy
ballon84117493_ballon
ballot84624093_ballot
callow114714663_callow
challa114014193chall_a
challah15458323challah
challas124414123challas
challie124012843challie
challis124613453challis
challoth16316103challoth
chally144314293chall_y
chalot113020133cha_lot
collop107312303_collop
dollop9259353_dollop
escallops1343173escallops
escalop1144783esca_lop
fallow124713853_fallow
gallon73715813_gallon
gallops103211653_gallops
galop84716213_ga_lop
hall75741163_hall__
hallah124115403_hallah
hallal94415563_hallal
hallel93514093_hallel
halloas104318463_halloas
halloed113314913_halloed
halloes104021513_halloes
halloos103716743_halloos
halloth134111253_halloth
hallows134417393_hallows
halls85633783_hall_s
hallux1637363_hallux
halo76437323_ha_lo_
halon86124863_ha_lon
halos85230253_ha_los
harlot94422803_harlot
hello86522983_hello_
hellos95321683_hellos
hillo84721653_hillo_
hilloa94713033_hilloa
hillos94618883_hillos
hilltop1244783_hilltop
hollo84822163_hollo_
holloa94914823_holloa
holloo94415253_holloo
hollos95320633_hollos
hollow124212663_hollow
hullo84417453_hullo_
hulloa95011183_hulloa
hulloo94511733_hulloo
hullos94916293_hullos
jalop144212603_ja_lop
lollop8238773_lollop
mallow114014743_mallow
pallor8313673_pallor
phalli1148263phall_i
phallic1447293phallic
phallus1236063phallus
phyllo1435873phyllo_
phyllos1535583phyllos
reallot7312133reallot
sailor63113743s_ailor
salep77022953s_a_lep
sall44544683s_all__
sallet63734543s_allet
sallows103915543s_allows
sallowy13369343s_allowy
sally85129713s_all_y
salmon84614183s_almon
salol55222143s_a_lol
salols64017873s_alols
salon55228553s_a_lon
saloon64418023s_aloon
saloops93510133s_aloops
salp64534093s_a_l_p
salvo84415643s_alvo_
salvor94711093s_alvor
salvos94613383s_alvos
sannop837373s_annop
sawlog1035793s_awlog
scaleup1134483scaleup
scall74420373scall__
scallion1046783scallion
scalloped1444463scalloped
scalloper1344453scalloper
scalls84218203scall_s
scalp95217983sca_l_p
scollops12235693scollops
shacko153810113shacko_
shackos16429023shackos
shadblow1742313shadblow
shadoof1446133shadoof
shadow1337253sha_dow
shahdom1643963shahdom
shakeup1632763shakeup
shako125516083sha_ko_
shakos134912183sha_kos
shale85332833sha_l_e
shaled105023953sha_led
shales94731253sha_les
shaley123714993sha_ley
shalier103116423shalier
shalloons1245213shalloons
shallowed1655083shallowed
shallower1555673shallower
shallowly1842613shallowly
shaloms1288983shaloms
shalt85534483sha_l_t
shaly114322863sha_l_y
shammos14307203shammos
shamos114216983sha_mos
shamoy14379913sha_moy
shampoo1435373shampoo
shapeup1443293shapeup
sharp104922533sha__rp
shaslik1444503shaslik
shaul85418103shaul__
shauled1148793shauled
shauls94913113shaul_s
shawl116217573shawl__
shawled1437773shawled
shawls125411973shawl_s
shell84424123shell__
shellac1236693shellac
shelled113815083shelled
sheller103515883sheller
shells94319523shell_s
shelly124414463shell_y
shill85325333shill__
shilled113313623shilled
shills94519603shill_s
shiplap1444513shiplap
shlep104914833sh__lep
shlepp13366193sh_lepp
shlump1345713sh_lump
sholom11910093sh_olom
shop95629833sh___op
slalom888173sla_lom
sloop76118913s__loop
slop66533873s___lop
small74016263small__
smaller93410333smaller
smallpox1941843smallpox
smalls84514123small_s
smalto84410283smalto_
smaltos9408193smaltos
spall74919303spall__
spalled103113123spalled
spaller92713473spaller
spalls84217343spall_s
stall54722353stall__
stalled83515683stalled
stallion837503stallion
stalls64019923stall_s
swallows14295883swallows
tallol63612223_tallol
tallow93714203_tallow
thalli958903thall_i
thallic1246533thallic
thalloid1246263thalloid
thallous1136523thallous
thallus1035603thallus
trollop944793trollop
unhallow14112343unhallow
wallops123410413_wallops
wallow123913513_wallow

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.1561145455.1
2DLD Change Limit1340271947.09618887.7
3Display Results1941940.0762552.6
 (SQL Overall)1786911947.32824384.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.