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

197 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
crudites113776(None) 
crudities1247741crudities
caudates11310262caudates
caudices13337342caudices
cerusites1146522cerusites
chedites1438262chedites
cordites11314622cordites
credited1238252credited
credits1039972credit_s
crinites10612762crinites
crudes96218622crud__es
crudity1336042crudit_y
cruises93514442cru_ises
curites93919862c_urites
erudite838482erudite_
acridines1247723acridines
acridities1348293acridities
alunites8310703alunites
arenites8917103arenites
aridities10911633aridities
audiles83112613_audiles
audited939033_audited
auditee8311573_auditee
auditees946463_auditees
audits72814113_audit_s
augites8312183_augites
azurites1737283azurites
bauxites1735153bauxites
braunites1146723braunites
brucines1237763brucines
bruises93212913bru_ises
bruited104110353bru_ited
bruiter93710633bru_iter
bruiters10329143bru_iters
bruits85714453bru_it_s
brutes86118683bru__tes
burdies104117563burdi_es
burkites1436673burkites
caddices14297853caddices
caddies113718383caddi_es
caddises12329353caddises
calcites12313003calcites
candies104125613candi_es
carditis11310223carditis
caudate10311353caudate_
caudated1238063caudated
caudexes1843843caudexes
caudles103912813caud_les
cerites94823433c_erites
cerusite1047763cerusite_
cerussites1243183cerussites
cheddites1643013cheddites
chedite1338863chedite_
chromites16310963chromites
chutes114615773chu__tes
cites74435593c___ites
codices12512583c_odices
coedited1237833coedited
coedits10310243coedit_s
coesites101313093coesites
cordite10315263cordite_
corodies11313693corodi_es
counties10316283counties
cowrites133011593cowrites
cradles103114133crad_les
craniates11310653craniates
crates85736063cr__ates
crazies183413853crazi_es
creates95225203cr_eates
credit9315193credit__
creditor1145903creditor
creditors1245873creditors
cremates124216003cremates
crevices1536713crevices
cries75438403cr__i_es
crimes105521583cr__imes
crinite9513633crinite_
cripes105120873cr__ipes
crises84529433cr__ises
crits75527573cr__it_s
crocoites1347463crocoites
cronies9622503croni_es
croutes94815653cr_outes
crowdies1437553crowdi_es
cruces105117543cru__ces
crucians1245293crucians
cruciate1287313cruciate_
crucibles1543743crucibles
crucifer1543683crucifer
crucifers1643333crucifers
crucifies1646123crucifies
crudded1235733crud_ded
cruddier1244153cruddier
cruddiest1334453cruddiest
crude86018573crud__e_
crudeness1245753crudeness
cruder95612383crud__er
crudest104510333crud__est
cruds85815853crud___s
cruelties1144893cruelties
cruets85314953cru_et_s
cruise84314043cru_ise_
cruised103710213cru_ised
cruiser93410433cru_iser
cruisers10438273cru_isers
crumbles14329683crumbles
crummies1437643crummies
crumpets14335943crumpets
crumples14348813crumples
crunches153711353crunches
crunodes1144973crunodes
crusades1146333crusades
cruses88127713cru__ses
crusets93811043cruset_s
crushes124215133cru_shes
crusted103712753cru_sted
crustier10259533crustier
crustiest112410053crustiest
crusts84916543cru_st_s
crutches15359593crutches
cruxes154911563cru__xes
cryolites1446963cryolites
cubits103714033c_ubit_s
cubitus11346783c_ubitus
cuddies113313263c_uddies
cuddles114014093c_uddles
culices113713123c_ulices
cuprites1259023cuprites
curates95323833c_urates
curdier103312623curdi_er
curdiest112511393curdi_est
curdles103814573curd_les
curettes1039313curettes
curies84934023c_uri_es
curite85222943c_urite_
curries93723163curri_es
cursives1337103cursives
cutes79438323c_u__tes
cuties84927363c_uti_es
cutises94414913c_utises
cutties93118843c_utties
cyanites132610163cyanites
dites66339153___dites
drudges10308873drud_ges
dunites8313593_dunites
endites83717063_endites
equites162212493equ_ites
eradiates102010783eradiates
eremites10312603eremites
eruditely1342703eruditely
exudates1636623exudates
frites94922483fr__ites
fruited11389093fru_ited
fruiter10309683fru_iter
fruiters11328183fru_iters
fruits94512493fru_it_s
gaudies9311973gaudi_es
gradates10510783gradates
gradines103615253gradines
granites92116363granites
grudges10349423grud_ges
gunites8313123_gunites
hurdies114015663hurdi_es
indites83618983_indites
leucites1037333leucites
lucites9311863_lucites
lyddites1342583lyddites
nudies75217093_nudi_es
nudities939683_nudities
ordines83014903or_dines
podites103014733_podites
predates11615813predates
preunites1138933preunites
prudes94215443prud__es
pruritus1043943pruritus
radiates92415293_radiates
radices102314263_radices
radixes15259343_radixes
ratites74920683_ratites
recites93524583_recites
redates83423873_redates
resites74027793_resites
reunites8312473reunites
rites54442553_r__ites
rubies84420343_rubi_es
ruddles92813873_ruddles
rutiles74315843_rutiles
studies82413863studi_es
suites63727403_su_ites
trudges9339993trud_ges
trusties82712853trusties
turgites937783turgites
unites65024853__unites
uralites82112723uralites
uranites82514643uranites
uridines989513uridines
writes94420333wr__ites

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621977.25020160.3
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.74923059.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.