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

150 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
cuspides1330694(None) 
cuspids12427111cuspid_s
auspices1236442auspices
cupids11369192cu_pid_s
cuspid11429212cuspid__
cuspidal1343472cuspidal
cuspidor1342122cuspidor
cuspidors1442172cuspidors
cuspis105010702cuspi__s
custodes1136652custodes
muspikes1635242muspikes
suspires1038202suspires
upsides10319632_upsides
apsides103911303aps_ides
aruspices1343353aruspices
asides75118873_as_ides
aspires9612043_aspires
aspises9611643_aspises
auspice1136523auspice_
besides104814533bes_ides
bicuspids1651823bicuspid_s
buppies133011063buppi_es
busbies113011693busbi_es
bushidos1443083bushidos
busies85525263bus_i_es
capizes20410373c_apizes
capsids1239333capsid_s
capsizes2147203capsizes
carbides133111693carbides
cascades13128553cascades
cassines103116613cassines
cassises103811743cassises
cestodes1138203cestodes
chides124620473c__hides
chopines152711733chopines
cissies94116153cissi_es
collides113214473collides
compiles14311983compiles
confides14310573confides
conspires1358483conspires
copies104130313c_opi_es
coppices1638243coppices
cosies84932163cos_i_es
cosines94122673cos_ines
cosmids1237633cosmid_s
cowhides1736013cowhides
cowpies143314283cowpi_es
crusades1146333crus_ades
cubbies133312883cubbi_es
cuboids1236723cuboid_s
cuddies113313263cuddi_es
cuisines1049373cuisines
culices113713123cu_lices
cullies94419963culli_es
cullises103111313cullises
cupid103212783cu_pid__
cuppier1368323cuppi_er
cuppiest1448203cuppi_est
cuppings15336053cuppings
cuprites1259023cuprites
cupules113210263cu_pules
curbsides1444483curbsides
curies84934023cu_ri_es
curites93919863cu_rites
curries93723163curri_es
cursives1337103cursives
cuscuses1235863cuscuses
cushier123610833cushi_er
cushiest133411043cushi_est
cushiness14197183cushiness
cushions1335693cushions
cuspate1138233cuspate_
cuspated1335913cuspated
cusped114312043cusp__ed
cuspidate1443573cuspidate
cusps94913673cusp___s
cusses84522773cus__ses
custodies1245963custodies
cuties84927363cu_ti_es
cutises94414913cu_tises
cutlines102413273cutlines
cutties93118843cutti_es
cyanides14258003cyanides
cystines1339473cystines
depsides1238503depsides
despises1139433despises
despites11410313despites
espies83716803_espi_es
guides84118283gu__ides
guppies123310523guppi_es
gussies82813303gussi_es
hospices1587633hospices
huipiles1344423huipiles
huskies143212083huski_es
hussies103213293hussi_es
huswifes1742723huswifes
huswives1742933huswives
insides8512653ins_ides
inspires1037623inspires
jussives1833843jussives
justices1737523justices
lapides103012043_lapides
lipides103810623_lipides
lupines93912503lu_pines
mudslides1343233mudslides
muscids12187973muscid_s
musjids17185713musjid_s
muskies133614673muski_es
muspike1536043muspike_
nuclides1146553nuclides
outrides92414993outrides
outsides92513233outsides
puppies103212623puppi_es
pussies93615693pussi_es
resides84523283res_ides
respades1139853respades
respires10311903respires
respites10513243respites
sides65838373__s_ides
slides73922183__slides
spades94222583__spades
spices104326033__spices
spider94516803__spider
spiders103914413__spiders
spies76037623__spi_es
spikes124520713__spikes
spiles84227913__spiles
spines85132033__spines
spires84628113__spires
spites84127333__spites
spodes94817433__spodes
subsides11410823subsides
suicides1139083suicides
sulfides1238053sulfides
sulphides1544693sulphides
supines94216383su_pines
suspire937803suspire_
suspired1135613suspired
topsides1137203topsides
tushies10312163tushi_es
tussises835433tussises
umpires1137813_umpires
unpiles92112783_unpiles
uppiles11208263_uppiles
upside9289803_upside_
upsizes18297163_upsizes
ureides8311103_ureides
vespids1334613vespid_s
wussies103411083wussi_es
yuppies14339263yuppi_es

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.453394461.4
2DLD Change Limit1461621507.72018932.9
3Display Results1501500.0602500.0
 (SQL Overall)1786911508.23321704.2
 
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.