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

185 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
cuspids1242711(None) 
cupids11369191cu_pids
cuspid11429211cuspid_
cuspides13306941cuspides
cuspis105010701cuspi_s
bicuspids1651822bicuspids
capsids1239332capsids
cosmids1237632cosmids
cuboids1236722cuboids
cupid103212782cu_pid_
cusped114312042cusped_
cuspidal1343472cuspidal
cuspidor1342122cuspidor
cuspidors1442172cuspidors
cusps94913672cusp__s
muscids12187972muscids
musjids17185712musjids
vespids1334612vespids
aspics104211563_aspics
aspis74618143_aspi_s
auspice1136523auspice
auspices1236443auspices
bicuspid1542463bicuspid_
buppies133011063buppies
busbies113011693busbies
bushido1344453bushido
bushidos1443083bushidos
bushpigs1642153bushpigs
busies85525263bus_ies
buskins133310943buskins
bustics11810883bustics
caids85226423c__aids
candids113812693candids
canids95118133c_anids
capias10318353c_apias
capsid11312413capsid_
caseins93115053caseins
cassias93514343cassias
cassis84818853cassi_s
caustics1237483caustics
cebids11439173c_ebids
ceboids1237653ceboids
cesspits1243663cesspits
cestoids11308273cestoids
chopins142312243chopins
cissies94116153cissies
cissoids1145363cissoids
clerids1049093clerids
clupeids1343243clupeids
coccids11277213coccids
conoids10813883conoids
copies104130303c_opies
corvids1337683corvids
cosies84932153cos_ies
cosmid11810643cosmid_
cousins9516003cous_ins
cowpies143314283cowpies
cubbies133312883cubbies
cubics123810163cu_bics
cubits103714033cu_bits
cuboid1139503cuboid_
cuddies113313263cuddies
cuds76730473cu___ds
cuifs104814693cu__ifs
culicids1345623culicids
cullies94419963cullies
cullis84115993culli_s
culprits1245583culprits
cumbias13338963cumbias
cumins103314933cu_mins
cummins1358963cummins
cupels10310203cu_pels
cuppas12458593cu_ppas
cupped134413983cupped_
cuppers133712213cuppers
cuppier1368323cuppier
cuppiest1448193cuppiest
cupping144312383cupping
cuppings15336053cuppings
cups85430823cu_p__s
curds85725613cu__rds
curies84934023cu_ries
curios83218333cu_rios
curries93723163curries
cuscus1038113cus_cus
cusecs10509153cus_ecs
cushats12288273cushats
cushaws15356293cushaws
cushier123610833cushier
cushiest133411043cushiest
cushily15257923cushily
cushion1236403cushion
cushions1335693cushions
cusks114916053cus__ks
cusp86021063cusp___
cuspal1037883cusp_al
cuspate1138233cuspate
cuspidate1443573cuspidate
cuss65430613cus___s
cussed94917123cussed_
cussers94213403cussers
cusses84522773cus_ses
cussing103814273cussing
cussos84210003cus_sos
custards11338393custards
custodes1136653custodes
custody1334093custody
customs11348263customs
custos84014313cus_tos
cuties84927363cu_ties
cutins83919983cu_tins
cutis77723763cu_ti_s
cutties93118843cutties
cyanids13297933cyanids
cystoids14306733cystoids
desmids1166603desmids
elapids1036503elapids
espies83716803_espies
fucoids1335663fucoids
fusains1038363fusains
fusils93912343fus_ils
fustics1279593fustics
guids75516153gu__ids
guppies123310523guppies
gussies82813303gussies
hispid1238173hispid_
huipils1243533huipils
huskies143212083huskies
hussies103213293hussies
jassids1586143jassids
lipids94310923_lipids
lupins84514463lu_pins
masjids17175403masjids
mucoids1237423mucoids
murids93212193mu_rids
muscid11219833muscid_
musics103911783mus_ics
musjid16216953musjid_
muskies133614673muskies
muskits13278563muskits
muslins9312213muslins
muspike1536043muspike
muspikes1635243muspikes
mysids1246563mys_ids
outbids1098913outbids
pulpits1137243pulpits
pupils10389913pu_pils
puppies103212613puppies
pushpins1543343pushpins
pussies93615693pussies
quids154917463qu__ids
rapids94913893_rapids
resids74219153res_ids
rustics9810733rustics
saids65328853__saids
salpids1038193salpids
sculpins12216473sculpins
skids104615323__skids
spics94123243__spics
spies76037623__spies
spiks114117473__spiks
spins75327983__spins
spits74429553__spits
spivs105114243__spivs
spuds85113673__spuds
stupids1035273stupids
sulfids1137293sulfids
sulphids1444373sulphids
sushis9311183sushi_s
susliks1136443susliks
suspends1145143suspends
suspire937803suspire
suspires1038203suspires
torpids1037373torpids
tricuspids1551613tricuspids
tupiks1235493tu_piks
tushies10312163tushies
tussis6379953tussi_s
unpins82312383_unpins
upside9289803_upside
upsides10319633_upsides
ursids737823_ursids
vespid1246083vespid_
wussies103411083wussies
yuppies14339263yuppies

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 Filter1786911340270.236757165.3
2DLD Change Limit1340271857.81317154.4
3Display Results1851850.1401321.4
 (SQL Overall)1786911858.18921820.9
 
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.