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

137 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
shellac123669(None) 
shellack1745081shellack
shellacs1345571shellacs
heliac111010892_heliac
sheila969842sheila_
sheilas1059402sheilas
shell84424122shell__
shellacks1844552shellacks
shellback2043602shellback
shelled113815082shelled
sheller103515882sheller
shells94319522shell_s
shelly124414462shell_y
shelta93111782shelta_
sheltas10279662sheltas
stella63612972stella_
stellar72610412stellar
stellas72813032stellas
avellan1037293avellan
celiac101910433_celiac
cella75420313_cella_
cellae84915933_cellae
cellar84514983_cellar
challa114014193challa_
challah15458323challah
challas124414123challas
chela103916803che_la_
chelae113614603che_lae
chelas113817203che_las
cholla113911023cholla_
chollas123811353chollas
coeliac1138233coeliac
fella84918653_fella_
fellah124910773_fellah
fellas95116963_fellas
hallah124115403_hallah
hallal94415563_hallal
hell75637893_hell__
hellcat12410173_hellcat
helled104024703_helled
heller93322513_heller
hello86522983_hell_o
hellos95321683_hellos
hells85032043_hell_s
holla84918493_holla_
hollas94616903_hollas
ocellar936533ocellar
paella8410913paella_
paellas9411413paellas
phallic1447293phallic
phellem1435833phellem
scilla8310943scilla_
scillas9310463scillas
selah8319613s_e_lah
sell45840613s_ell__
selle54428313s_ell_e
seller63824593s_eller
selles64426983s_elles
sells55134433s_ell_s
selva83014273s_elva_
selvas93812913s_elvas
serac75925203s_e_rac
shall85024053shall__
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shea76031573she__a_
sheaf115424123she__af
sheal84927703she__al
sheals94420643sheal_s
shear85424833she__ar
sheas86331793she__as
shebean1235763shebean
sheitan1036563sheitan
shelduck1862063shelduck
shelf115221113she_l_f
shellacked2042003shellacked
shellbacks2153403shellbacks
shellbark1843013shellbark
shellers112812563shellers
shellier1138393shellier
shelling123515213shelling
shelter103214953shelter
sheltie10109893sheltie
shelty124011543she_lty
shelve124012763she_lve
shelved14379933shelved
shelver134211063shelver
shelves134112093shelves
shelvy15377863she_lvy
sheol84318363sheol__
sheols94614153sheol_s
sherlock1744243sherlock
sherpa1138093sherpa_
sherpas1238093sherpas
shetland1244633shetland
shigella1243053shigella_
shigellae1342723shigellae
shigellas1343143shigellas
shill85325333shill__
shillala11143783shillala
shilled113313623shilled
shills94519603shill_s
shiplap1444513shiplap
shoeblack2043153shoeblack
shoelace1345293shoelace
shoepac1444003shoepac
shtetlach1751483shtetlach
skell94915833skell__
skells105013783skell_s
skellum1343843skellum
smell74916233smell__
smelled103511853smelled
smeller94212783smeller
smells83914743smell_s
smelly114110353smell_y
snell54517303snell__
snelled83313043snelled
sneller73512843sneller
snells64614203snell_s
spelean937123spelean
spell75020303spell__
spelled103714733spelled
speller95415143speller
spells84617683spell_s
stela54019043ste_la_
stelae63716483ste_lae
stelai63912563ste_lai
stelar64013863ste_lar
stelic8313083ste_lic
stellate8310503stellate
swell84815983swell__
swelled113211693swelled
sweller103012463sweller
swells93913983swell_s
thallic1246543thallic
theriac1239143theriac

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271376.22021547.7
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.41927837.8
 
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.