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

290 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
cercises1241093(None) 
cerises94722251cer_ises
carcases12313082carcases
cercis104614492cerci__s
cereuses1049242cereuses
cerise84822042cer_ise_
cerites94823432cer_ites
ceruses93716232cer_uses
cervices1537132cervices
cervixes2054602cervixes
circuses1238252circuses
crises84529432c_r_ises
cruises93514442c_ruises
dermises112512022dermises
derrises93012782derrises
excises1638932_excises
exercises1846462exercises
kermises14248312kermises
mercies113817562merci_es
merises93421422mer_ises
precises123218332precises
reraises8415642reraises
rerises73525882rer_ises
abscises1246233abscises
aegises8311373ae_gises
aeries64737783aer_i_es
arcuses94814693_arcuses
arises65233803_ar_ises
arrises71617583_arrises
becrimes1467073becrimes
berceuses1344103berceuses
berimes115216643ber_imes
berlines102315453berlines
berries94423553berri_es
betises94816123be_tises
braises93818873_braises
brewises1337213brewises
brises84927613_br_ises
bruises93212913_bruises
caddises12329353caddises
calcines12314753calcines
calcites12313003calcites
camises114218463c_amises
carbides133111693carbides
carbines123617533carbines
carcase11312733carcase_
carcass11310513carcas_s
carcasses1337473carcasses
cardcases1446493cardcases
caresses10314063caresses
caribes113715643car_ibes
carices114220953car_ices
caries85147623car_i_es
carlines103521643carlines
carmines123617863carmines
carnies94123963carni_es
carouses10614503carouses
carries94328013carri_es
carses85233653car__ses
cassises103811743cassises
caucuses1236783caucuses
ceases84427073ce__ases
cecities12312043ce_cities
cellists1038563cellists
censes83721803ce__nses
censuses10187543censuses
centeses1079443centeses
centiles103615813centiles
centimes124012613centimes
ceramides1447453ceramides
ceramists1346723ceramists
cerastes101111093cerastes
cerates95428253cer_ates
cerci93716393cerci___
cercus105013153cerc__us
ceres75540013cer___es
cerias83321983cer_i_as
ceriphs1484753cer_iphs
cerite84724873cer_ite_
ceriums1139473cer_iums
certes84623083cer__tes
certifies14310323certifies
ceruse83914523cer_use_
cerusites1146523cerusites
cervine122610803cervine_
cesses84221363ce__sses
cestuses1038083cestuses
ceviches1834843ceviches
chaises124317493c_haises
chamises153513313chamises
chemises153211983chemises
cherishes1767563cher_ishes
cherries131812983cherri_es
chrisms1499143chr_isms
circles1139903circ_les
clergies1137903clergi_es
clerisies1147253cler_isies
clevises1336903clevises
coerces11311943coerc__es
coercions1346203coercions
coercive1545873coercive_
cognises11610043cognises
concise11314473concise_
conciser12310243conciser
concisest1348253concisest
corbies113520123corbi_es
cordites11314623cordites
cornices12713293cornices
cornuses10310033cornuses
corpses113913803cor_pses
corpuses12310063corpuses
corries94026793corri_es
corses84433463cor__ses
cortices12615013cortices
crases85532313c_r_ases
creases94020963c_reases
creches14313093crec_hes
creeses93914623c_reeses
creolises1157893creolises
cresses94219813c_resses
crevices1536713crevices
cries75438403c_r_i_es
crimes105521583c_r_imes
cripes105120873c_r_ipes
crisis83716343c_r_isis
crisps104411513c_r_isps
crocuses1239023crocuses
crosses94220793c_rosses
cruise84314043c_ruise_
cruised103710213c_ruised
cruiser93410433c_ruiser
cruisers10438273c_ruisers
cruses88127713c_r_uses
cullises103111313cullises
curacies12311763curaci_es
curches143512743curc_hes
curies84934023cur_i_es
curites93919863cur_ites
curries93723163curri_es
curses85328273cur__ses
cursives1337103cursives
curtsies1038733curtsies
cuscuses1235863cuscuses
cutises94414913c_utises
cycases1437533c_ycases
debruises1243633debruises
decides114217653de_cides
deciles104417723de_ciles
decries103319803decri_es
deicides1249303deicides
deixises1635693deixises
demises103719563de_mises
derbies103016053derbi_es
derides93420853der_ides
derives114017813der_ives
derries83124623derri_es
dervishes1644933dervishes
despises1139433despises
devises114116763de_vises
ecesises1037023ecesises
ecocides1346583ecocides
egises7312493_e_gises
encases93116053_encases
energises1047063energises
erases64425403_er_ases
ermines9416673_ermines
eroses65327053_er_oses
erses55826803_er__ses
eternises9119453eternises
excides1738343_excides
excise1538553_excise_
excised1736673_excised
excites16310633_excites
excuses1638903_excuses
exercise1747063exercise_
exercised1944633exercised
exerciser1844113exerciser
exercisers1942853exercisers
exorcises1845693exorcises
farcies125317883farci_es
ferlies103216693ferli_es
ferries103521083ferri_es
ferrites112312833ferrites
forcipes1535943forcipes
fraises104215693_fraises
frises94124273_fr_ises
gearcases1254693gearcases
genoises939253genoises
glacises1138503glacises
grecizes2035683grecizes
hercules1337633hercules
heresies11312693heresies
heroines112916573heroines
heroisms1338693heroisms
heroizes202610983heroizes
herries104025073herri_es
incises93414893_incises
irises64221173_ir_ises
jerkies183411583jerki_es
jerries143817513jerri_es
kernites1269113kernites
kerries113317913kerri_es
krises105016083_kr_ises
laicises1039573laicises
leucines1037273leucines
leucites1037333leucites
lewises1039133le_wises
lorises73918593lor_ises
lyricises149810873lyricises
mercerises1446193mercerises
merces105720743merc__es
merches144013763merc_hes
merciless1344473merciless
merisis93213173mer_isis
morrises10711073morrises
mortises10713613mortises
narcisms1267263narcisms
narcists1078113narcists
narcoses103910543narcoses
necroses10310563necroses
nereides938503nereides
nervines112310463nervines
orchises1338773_orchises
orrises71312233_orrises
parises94827183par_ises
parvises133911913parvises
peises84125043pe__ises
pelvises1337273pelvises
penises9318193pe_nises
percales12313803percales
perceives1646313perceives
perches143717953perc_hes
percuss1137163percus_s
percusses1346503percusses
perfuses1358663perfuses
perishes13313753per_ishes
perlites10316363perlites
perries93226603perri_es
perses85428063per__ses
persists1049183persists
peruses94018163per_uses
praises94121103_praises
precipes143212213precipes
precise113518173precise_
precised133213413precised
preciser123411663preciser
precisest13259003precisest
premises123018273premises
previses133814283previses
prises84133173_pr_ises
raises64826543__raises
realises82420183realises
recipes113314463re_cipes
recites93524583re_cites
recuses94619463re_cuses
remises93423483re_mises
reprises102615463reprises
reraise7316313reraise_
reraised9312353reraised
rerise64325633rer_ise_
rerisen73613643rer_isen
revises104220533re_vises
rises55244043__r_ises
seises64026713se__ises
semises93916553se_mises
series64540973ser_i_es
serines74229543ser_ines
serries73925353serri_es
services1338573services
sherrises12156863sherrises
surmises10310643surmises
tennises82810133tennises
terces83921413terc__es
tergites9310543tergites
termites10313693termites
terrases82111483terrases
terries73425633terri_es
terrines82117553terrines
upraises10188473upraises
uprises92012733upr_ises
verbiles1338923verbiles
verisms123011253ver_isms
verists103613673ver_ists
verites103822263ver_ites
vernixes1836053vernixes
verses94223763ver__ses
versines112213823versines
vertices13612283vertices
xeroses143612823xer_oses
xeruses143010753xer_uses

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 Limit1461622907.20320291.8
3Display Results2902900.1232357.7
 (SQL Overall)1786912907.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.