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

376 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
crewels1243848(None) 
creels84416941cre_els
crenels93711011crenels
crewel114310471crewel_
brewers123811052brewers
chewers154111132chewers
crawls114712082craw_ls
creeds94714772cre_eds
creeks124812922cre_eks
creel75121482cre_el_
creeps104213622cre_eps
cremes104517992creme_s
crenel84213062crenel_
creoles9913322creoles
crepes105419342crepe_s
cresols939642cresols
cresyls1234752cresyls
crewed125316552crewe_d
crewless1335402crewless
crews105917492crew__s
crowers124614892crowers
jewels16508612_jewels
krewes1337922krewe_s
newels93710822_newels
rebels84518132_rebels
reels55333262_re_els
refels94618052_refels
repels84318762_repels
revels94220572_revels
reweds104412302_reweds
reweld103711112_reweld
rewelds11457412_rewelds
rewets94617212_rewets
rowels94515452_rowels
screwers13358052screwers
trowels10358362trowels
arenes64928393arene_s
areoles71016953areoles
aretes64425353arete_s
ariels65119373ar_iels
artels66216233ar_tels
bedels94015273_bedels
bejewels2042483bejewels
betels84515063_betels
bevels113913983_bevels
bezels173712283_bezels
bowels114315593_bowels
brawls115214333braw_ls
bredes94818473brede_s
breeds94914883bre_eds
breeks125310793bre_eks
brees75632553bre_e_s
breves115516423breve_s
brevets12519393brevets
brewed125411873brewe_d
brewer114812543brewe_r
brewery15376953brewery
brewis11469983brew_is
brews105617073brew__s
camels105217083c_amels
cancels114113313cancels
cannels93413363cannels
caramels1238803caramels
caravels1337433caravels
carcels114516063carcels
careens94514703care_ens
careers95218783care_ers
careless102813633careless
carpels115315463carpels
carrels95117303carrels
cartels94618123cartels
carvels124914593carvels
ceders93817673c_eders
cedes84927323c_ede_s
cees65941593c_e_e_s
ceils75019403c_e_ils
celebs1037883c_elebs
cells75428063c_e_lls
cels65534973c___els
ceorls848163c_eorls
cepes94424463c_epe_s
cereals9313173cereals
ceres75540013c_ere_s
cereus85215523c_ereus
cermets1139713cermets
certes84623083certe_s
cervelas1344673cervelas
cetes75731103c_ete_s
chapels14429153chapels
chawers154412033chawers
chebecs1635013chebecs
cheders134512393cheders
cheeks154712783che_eks
cheeps135312913che_eps
cheers114518913che_ers
chewed154415013chewe_d
chewer145512613chewe_r
chews135418513chew__s
chiels115115933c_hiels
chisels12219103chisels
clawers123910963clawers
cleeks125010543cle_eks
clepes104214623clepe_s
clewed1225113203clewe_d
clews105516333clew__s
cobwebs1631933cobwebs
coevals1237873coevals
compels133210883compels
corbels113813593corbels
coreless103013833coreless
cormels113813373cormels
cornels94716663cornels
coronels104012143coronels
cowers114625533c_owers
cowls106922213c_ow_ls
craals84113303cr_aals
cradles103114123cradles
crakes124921813crake_s
cranes84330753crane_s
crapes104727693crape_s
crases85532313crase_s
craters95021883craters
crates85736053crate_s
cravens124010113cravens
cravers124416543cravers
craves115825393crave_s
crawl104916713craw_l_
crawled133710393crawled
crawler123510453crawler
crawlers13309003crawlers
crawly144610763craw_ly
craws105723123craw__s
crazes174720133craze_s
creaks124315963cre_aks
creamers124111293creamers
creams104715253cre_ams
creasers103612813creasers
creases94020963creases
creates95225173creates
creches14313093creches
credal9311673credal_
credent10313973credent
credits1039973credits
credos94612843cre_dos
creds85418773cr__eds
creed85727393cre_e_d
creek114917393cre_e_k
creeled104012013cre_eled
creep95218103cre_e_p
creepers12318623creepers
creepy13418803cre_epy
creese84014333cre_ese
creeses93914623creeses
creesh11328333cre_esh
creme94319323creme__
creneled11326893creneled
crenelle1046333crenelle
crenelles1146733crenelles
creole8913723cre_ole
creosols1045713creosols
crepe95520723crepe__
creped114115703crepe_d
crepey135110933crepe_y
crepons1139313crepons
cresol8310203cresol_
cress75022833cr__ess
cresses94219813cresses
cressets10309103cressets
crests85218703cre_sts
cresyl1135133cresyl_
cretics112911653cretics
cretins93216423cretins
crew96122673crew___
crewcut1445013crewcut
crewcuts1542173crewcuts
crewing133212623crewing
crewman1435743crewman
crewmen1436373crewmen
crewneck1942113crewneck
crewnecks2041753crewnecks
criers83918583cr_iers
cries75438403cr_ie_s
crimes105521583crime_s
cripes105120873cripe_s
crises84529433crise_s
crones84729243crone_s
crores86121163crore_s
crowders14398793crowders
crowds124910763crow_ds
crowed124717293crowe_d
crower114117553crowe_r
crowners133710743crowners
crownets13407673crownets
crowns115615113crow_ns
crows105727313crow__s
crozers184111083crozers
crozes174417663croze_s
cruces105117543cruce_s
crudely1336273crudely
crudes96218623crude_s
cruel74815903cr_uel_
cruets85314953cr_uets
cruses88127713cruse_s
crusets93811043crusets
cruxes154911563cruxe_s
crwths1433433cr_wths
cudgels1135333cudgels
cupels10310203c_upels
cureless10319703cureless
cyeses11510123cyese_s
devels104313903_devels
diesels8429143diesels
djebels1753293djebels
dowels104813343_dowels
drawees11378363drawees
drawers113610073drawers
drawls105511393draw_ls
drees65628523dre_e_s
dreidels1033213dreidels
dreidls934053dreidls
drivels11397923drivels
drywell1442373drywell
drywells1542113drywells
eels46536743__e_els
ewers86018823__ewers
ewes76328703__ewe_s
farewell1443313farewell
farewells1543073farewells
feels85223043_fe_els
ferrels10248623ferrels
freely12310953fre_ely
freers94717303fre_ers
frees86131393fre_e_s
freres94716173frere_s
fresnels1135233fresnels
gravels113611143gravels
grebes93813613grebe_s
greeds84314283gre_eds
greens75716873gre_ens
grees65132473gre_e_s
greets75117423gre_ets
grovels11427813grovels
growers113612723growers
growls104711113grow_ls
gruels73910153gr_uels
heels85625533_he_els
hewers123715273_hewers
ireless72312243ireless
jebels15418913_jebels
jewel156711703_jewel_
keels94622413_ke_els
kernels11417953kernels
kevels134410713_kevels
knawels14344683knawels
kneels10408933kne_els
kreeps12427413kre_eps
krewe1238193krewe__
levels94113283_levels
mewls105813233_mew_ls
newel86114133_newel_
oriels64914623or_iels
peels75226423_pe_els
peewees1236803peewees
pewees11311393_pewees
precess11310863precess
preens85020113pre_ens
prees75937173pre_e_s
prefers123713333prefers
premeds12389583premeds
prequels1934833prequels
presell939293presell
presells1058273presells
presets94216423presets
pretell938233pretell
pretells1047323pretells
pretzels1934033pretzels
prexes154915943prexe_s
preyers124412363preyers
prezes173614693preze_s
propels113412843propels
prowess1237903prowess
prowls115511083prow_ls
ratels64518213_ratels
ravels94717073_ravels
reales64934123_reales
reals55038653_re_als
rebecs103913673_rebecs
rebel73421293_rebel_
recess8314263_recess
redes65139123_rede_s
reeds65430903_re_eds
reefs85121663_re_efs
reeks94124033_re_eks
reel45240533_re_el_
rees45364193_re_e_s
refeels10379693_refeels
refel84920813_refel_
refell94214443_refell
refelt94521423_refelt
refers93921083_refers
refuels10399523_refuels
reges65628783_rege_s
reheels10298253_reheels
rehems113410983_rehems
rekeys13347693_rekeys
relets64025673_relets
remelt85123123_remelt
remelts93511493_remelts
renews93811753_renews
reoils64516873_reoils
repeals94014523_repeals
repegs93311943_repegs
repel74921403_repel_
reseals73917663_reseals
resees63827483_resees
resell64215203_resell
resells73313203_resells
resets65427613_resets
resews94814173_resews
retell63813643_retell
retells73211523_retells
retems83914573_retems
reveals103812723_reveals
revel84423163_revel_
revers94529633_revers
revets94022173_revets
rewear93011993_rewear
rewears102911033_rewears
rewed95425453_rewe_d
rewet85135153_rewe_t
rewins95020823_rewins
rexes124526953_rexe_s
riels55121333_r_iels
rowel84721413_rowel_
rowens94515303_rowens
rowers94924573_rowers
rubels84112993_rubels
scrawls12177273scraw_ls
screeds106210283scre_eds
screens95212173scre_ens
screes85023963scre_e_s
screwed135710653screwe_d
screwer124410063screwe_r
screws115513883screw__s
screwups1542283screwups
seels55632823_se_els
sewers94719713_sewers
shekels1436043shekels
sheqels1934753sheqels
shewers134312043shewers
skewers14498373skewers
speels85116393spe_els
spewers124210653spewers
steels64117983ste_els
streels73811343stre_els
strewers11409053strewers
teels55726373_te_els
tercels94110363tercels
towels94314643_towels
tramels93812493tramels
travels104711293travels
trawls94412393traw_ls
trebles9311443trebles
treens65317873tre_ens
trees55835763tre_e_s
tressels8367653tressels
trevets10499973trevets
trews86118893trew__s
trowel94211463trowel_
unreels7258313unre_els
ureters7311823ureters
viewers1337173viewers
vowels124410483_vowels
wedels103811033_wedels
weewees1336563weewees
wheels123811713whe_els

Search took 10 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.1561145455.1
2DLD Change Limit1340273769.42314223.4
3Display Results3763760.1233056.9
 (SQL Overall)1786913769.70218418.0
 
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.