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 “shellacs” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
shellacs134557(None) 
shellac1236691shellac_
shellack1745081shellack
shellacks1844551shellacks
sheilas1059402sheila_s
shellback2043622shellback
shellbacks2153422shellbacks
shellers112812582shellers
shells94319522shell__s
sheltas10279672shelta_s
stellas72813042stella_s
celiacs11157893_celiacs
cellars93713693_cellars
challahs16377563challahs
challas124414123challa_s
chelas113817203che_la_s
chollas123811353cholla_s
fellahs13428393_fellahs
fellas95116963_fella_s
hallahs133912463_hallahs
heliac111010893_heliac_
hellcat12410173_hellcat
hellcats1346323_hellcats
hellers103619833_hellers
helloes103717473_helloes
hellos95321683_hell_os
hells85032043_hell__s
hollas94616903_holla_s
paellas9411423paella_s
phellems1544543phellems
scillas9310473scilla_s
selahs9313213s_e_lahs
sellers73721323s_ellers
selles64426983s_ell_es
sells55134433s_ell__s
selvas93812913s_elva_s
seracs84418573s_e_racs
shallops13288323shallops
shallots11319503shallots
shallows14388863shallows
sheafs124912883she__afs
sheals94420643she__als
shears93820903she__ars
sheas86331793she__a_s
shebeans1344703shebeans
sheila969843sheila__
sheitans1155603sheitans
shelduck1862063shelduck
shelducks1951913shelducks
shell84424123shell___
shellacked2042013shellacked
shellbark1843033shellbark
shellbarks1952633shellbarks
shelled113815093shell_ed
sheller103515893shell_er
shellfish1843223shellfish
shellier1138403shellier
shelliest1238033shelliest
shelling123515213shelling
shelly124414473shell__y
shelta93111793shelta__
shelters113412813shelters
shelties111111383shelties
shelvers14388813shelvers
shelves134112093she_lves
sheols94614163sheol__s
sherlock1744243sherlock
sherlocks1843953sherlocks
sherpas1238093sherpa_s
shetland1244633shetland
shetlands1343743shetlands
shigellas1343143shigella_s
shillala11143803shillala
shillalas12133293shillalas
shills94519613shill__s
shiplaps1544363shiplaps
shoeblack2043153shoeblack
shoeblacks2153013shoeblacks
shoelace1345303shoelace
shoelaces1445243shoelaces
shoepacs1543833shoepacs
shtetlach1751483shtetlach
skells105013783skell__s
skellums1443003skellums
smellers10329773smellers
smells83914743smell__s
snells64614203snell__s
spellers102812763spellers
spells84617683spell__s
stella63612973stella__
stellar72610443stella_r
stellate8310503stellate
swells93913983swell__s
theriacs1336543theriacs

Search took 9 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.423422437.4
2DLD Change Limit146162947.51619446.8
3Display Results94940.0761236.8
 (SQL Overall)178691948.01522294.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.