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

255 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
cereuses104924(None) 
ceruses93716231cer_uses
berceuses1344102berceuses
caresses10314062caresses
carouses10614502carouses
censuses10187542censuses
cercises12410932cercises
cereus85215522cereu__s
cerises94722252cer_ises
ceruse83914522cer_use_
cestuses1038082cestuses
circuses1238252circuses
coleuses1039712coleuses
cornuses10310032cornuses
corpuses12310062corpuses
creases94020962c_reases
creeses93914622c_reeses
cresses94219812c_resses
cruses88127712c_r_uses
perfuses1358662perfuses
peruses94018162per_uses
reuses66025522__reuses
xeruses143010752xer_uses
actresses1137933actresses
airbuses1067073airbuses
arcuses94814693_arcuses
arguses84711743_arguses
arouses74921293_arouses
bemuses1139293be_muses
berceuse1243433berceuse_
bereaves1338263bereaves
boreases10310253boreases
cactuses1237933cactuses
caestuses1144893caestuses
calluses1039323calluses
campuses1437773campuses
carcases12313083carcases
careless102813633careless
caress85720263care_s_s
caressed1139163caressed
caresser1038803caresser
caressers1137433caressers
caroluses1157613caroluses
carouse9614423carouse_
caroused1149253caroused
carousel1057313carousel
carousels1165343carousels
carouser1068843carouser
carousers1156733carousers
carses85233653car__ses
caseases10410473caseases
caseoses1039293caseoses
cateresses1248353cateresses
caucuses1236783caucuses
causes88026473c__auses
cayuses12188403c_ayuses
ceases84427073c__eases
celeries10316313celeries
celestes10310013celestes
cellules1036813cellules
censes83721803c__enses
censures102211623censures
censused11184973censused
centeses1079443centeses
cerastes101111093cerastes
cerates95428233cer_ates
cercus105013153cercu__s
cereals9313173cere_als
ceres75540013cer___es
cerise84822043cer_ise_
cerites94823433cer_ites
ceriums1139473ceriu_ms
cernuous1055013cernuous
cerous85821203cerou__s
certes84623083cer__tes
cerumen1147763cer_umen
cerumens1235763cer_umens
cerusites1146523cer_usites
cervelases1542923cervelases
cervices1537133cervices
cervixes2054603cervixes
cesses84221363c__esses
charmeuses1743093charmeuses
cheeses123613103c_heeses
chesses124112633c_hesses
chiauses1336483chiauses
choreguses1642973choreguses
choruses1339983choruses
chouses125117813c_houses
cirques1836463cirqu_es
cistuses1038283cistuses
citruses1037483citruses
clauses93813323c_lauses
clonuses1057133clonuses
coituses1039623coituses
confuses13310363confuses
contuses10413453contuses
coreless103013833coreless
corpses113913803cor_pses
corses84433463cor__ses
crases85532313c_r_ases
crease85519573c_rease_
creased104315583c_reased
creaser94415723c_reaser
creasers103612813c_reasers
creates95225173c_reates
creches14313093c_reches
creepies1239613creepies
creese84014333c_reese_
creeshes1336953creeshes
cremes104517993c_re_mes
creoles9913323c_reoles
crepes105419343c_re_pes
cress75022833c_re_s_s
cresset93319943c_resset
cressets10309103c_ressets
crests85218703c_re_sts
crises84529433c_r_ises
crocuses1239023crocuses
crosses94220793c_rosses
croupes114613103c_roupes
crouse84619363c_rouse_
croutes94815643c_routes
cruces105117543c_r_uces
crudes96218623c_r_udes
cruises93514443c_ruises
cruse75726103c_r_use_
cruset84425093c_r_uset
crusets93811043c_r_usets
crushes124215133c_r_ushes
crusts84916543c_r_usts
cruxes154911563c_r_uxes
cultuses1037753cultuses
cureless10319703cureless
curettes1039313curettes
curses85328273cur__ses
cuscuses1235863cuscuses
cyeses11510123c_ye_ses
cypreses1535143cypre_ses
cypresses1645853cypresses
cypruses1534313cypruses
deceases11410153deceases
decreases1237223decreases
defenses1237913defenses
defuses114814593de_fuses
degreases1146153degreases
delouses9310013delouses
depresses1259873depresses
dermises112512023dermises
derrises93012783derrises
diereses938693diere_ses
diseuses93112763diseuses
dresses83716173_dresses
druses75517253_dr_uses
duresses939173duresses
effuses1335903_effuses
egresses949443egresses
emeses86114963_eme_ses
emeutes938013_emeutes
erases64425403_er_ases
eroses65327053_er_oses
erses55826803_er__ses
excuses1638903_excuses
ferrules1136163ferrules
ferules103112723fer_ules
fetuses10310243fe_tuses
geneses82613523gene_ses
geniuses935933geniuses
genuses83510883ge_nuses
greases84816713_greases
grouses84616543_grouses
heiresses1236963heiresses
hercules1337633hercules
heredes11313133here_des
heresies11312693heresies
icehouses1445003icehouses
icteruses1144963icter_uses
ileuses738673_ileuses
kermesses15284963kermesses
kermises14248313kermises
meatuses1038203meatuses
merises93421423mer_ises
neguses837933ne_guses
nemeses948663neme_ses
nereides938503nereides
nervules1145013nervules
nervures1135123nervures
nexuses1436743ne_xuses
ogresses938473ogresses
overuses11312643over_uses
pareses94718873pare_ses
peeresses1138453peeresses
pepluses1287013pepluses
percuss1137163percus_s
percusses1346503percusses
perdues103511333perdu_es
perdures11289683perdures
perfumes1555893perfumes
perfuse1247663perfuse_
perfused1445823perfused
perjures17268083perjures
permeases1347093permeases
permutes1238713permutes
perses85428063per__ses
pertusses1145383pertusses
perukes133210113per_ukes
peruse84016843per_use_
perused103112183per_used
peruser93511373per_user
perusers10328803per_users
phereses1348093phere_ses
presses93523153_presses
rearouses9310203rearouses
rebuses94915293re_buses
recesses10312323recesses
recluses105111733recluses
recuses94619463re_cuses
redresses10410293redresses
refuses104918553re_fuses
regresses10310463regresses
rehouses11312113rehouses
releases8313343releases
represses11412143represses
reraises8415633reraises
reredoses1045773reredoses
rerises73525883rer_ises
reroutes8312223reroutes
reuse56025363__reuse_
reused75419563__reused
reverses112513513reverses
rhuses94911793__rhuses
rouses65436283__rouses
ruses56136583__r_uses
seeresses939053seeresses
serenes73222903sere_nes
soleuses838073soleuses
stresses81112493stresses
streusel843933streusel
streusels942933streusels
teleses7313123tele_ses
terrases82111453terrases
tresses73719543_tresses
uprouses1037553uprouses
uraeuses835383uraeuses
ureases74416723_ureases
uruses63616503_ur_uses
uteruses837183uter_uses
varuses10310623var_uses
vendeuses1343393vendeuses
venuses103111413ve_nuses
verdures12247743verdures
verses94223763ver__ses
viruses1039413vir_uses
whereases1545673whereases
xeroses143612823xer_oses

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.1561145455.1
2DLD Change Limit1461622557.43619656.0
3Display Results2552550.1102318.2
 (SQL Overall)1786912557.70223200.6
 
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.