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

526 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
creesh1132833(None) 
creese84014331creese
breech13348262breech
brees75632552brees_
cees65941592c_ees_
ceres75540012ceres_
cheese113812762cheese
cheesy14419192cheesy
crash109120012cr_ash
crease85519572crease
creasy114612302creasy
creds85418772creds_
creed85727392cree_d
creeds94714772creeds
creek114917392cree_k
creeks124812922creeks
creel75121482cree_l
creels84416942creels
creep95218102cree_p
creeps104213622creeps
creepy13418802creepy
creeses93914622creeses
creeshed1435692creeshed
creeshes1336952creeshes
cremes104517992cremes_
crepes105419342crepes_
cress75022832cr_ess
cressy11439112cressy
crest74632692cr_est
crews105917492crews_
cries75438402cries_
crush106815992cr_ush
drees65628522drees_
frees86131392frees_
freest95318282freest
fresh115012202fr_esh
grees65132472grees_
prees75937172prees_
rees45364192_rees_
reest54938092_reest
resh76523452_r_esh
screech1435212screech
screes85023962screes_
sheesh1237812sheesh
sneesh945892sneesh
trees55835762trees_
ackees124914573ackees_
acres76327763acr_es_
afresh1255503afresh
agrees74915323agrees_
akees96119243akees_
areas55935773areas_
arenes64928393arenes_
ares45871023ar_es_
aretes64425353aretes_
arles56735743arles_
arrest63722633arrest
arses55733873arses_
beech124315503_beech
bees65453383_bees_
braes75735053braes_
brash106221563br_ash
breach134213723breach
breast8319633breast
breath113916263breath
bredes94818473bredes_
bree67241263bree__
breed85526693bree_d
breeds94914883breeds
breeks125310793breeks
breeze17298963breeze
breezy20295853breezy
brens75823363brens_
breves115516423breves_
brews105617073brews_
bries74942153bries_
brush105917473br_ush
cades85440733cades_
cafes106426923cafes_
cages85936013cages_
cakes116037673cakes_
calash11312433calash
calesa8412473calesa
cames97047313cames_
canes75350373canes_
capes95441923capes_
careen84119493caree_n
careens94514703careens
career85822243caree_r
careers95218783careers
careless102813633careless
carers85133953carers_
cares77369183cares_
caress85720263caress
carets85330773carets_
caries85147623caries_
carles85435083carles_
carless95118493carless
carlish12312763carlish
carses85233653carses_
cartes86239473cartes_
carves115128453carves_
carwash1535993carwash
cases75048383cases_
cash96636283c__ash
cates75951873cates_
caves105639703caves_
cease75227653c_ease
cedes84927323cedes_
cee55952703c_ee__
cels65534973c_els_
cense75121403c_ense
cepes94424463cepes_
ceps86125953c_eps_
cere66741473cere__
cereal8315833cereal
cered85227443cere_d
cereus85215523cereus
ceriph1398463ceriph
cerise84822043cerise
ceros74726073ceros_
certes84623083certes_
ceruse83914523ceruse
cess65326053c__ess
cetes75731103cetes_
cheek145115713chee_k
cheeks154712783cheeks
cheeky18448613cheeky
cheep125416503chee_p
cheeps135312913cheeps
cheer105420383chee_r
cheero114712933cheero
cheers114518913cheers
cheery144913153cheery
cheesed133910683cheesed
cheeses123613103cheeses
cheetah1545453cheetah
chefs136214663chefs_
cherish15310463cherish
chess105016923c_hess
chest104926143c_hest
chetah14399583chetah
cheth135013823c_heth
cheths14389823cheths
chews135418513chews_
choush14549063choush
cines75239683cines_
cires74932913cires_
cites74435583cites_
clash106219033c_lash
cleek115514913clee_k
cleeks125010543cleeks
clefs106616243clefs_
clench133910053clench
clepes104214623clepes_
clews105516333clews_
clues74623033clues_
codes86247293codes_
coeds85920163coeds_
cohosh14517123cohosh
cokes115537193cokes_
coles76055063coles_
comes97246993comes_
cometh134811683cometh
cones76457423cones_
cooees85621893cooees_
copes97747103copes_
coreless103013833coreless
corers85231073corers_
cores76361853cores_
corses84433463corses_
corvees124613793corvees_
corves115122523corves_
coses76949493coses_
cosh96127623c__osh
cotes76347843cotes_
coves105539173coves_
coxes145430863coxes_
coyest11316053coyest
coyish143710393coyish
cozes166033243cozes_
crabs95421393crabs_
crags85622573crags_
crakes124921813crakes_
crams96229153crams_
cranch133613533cranch
cranes84330753cranes_
crapes104727693crapes_
craps95328643craps_
crases85532313crases
crass76328043cr_ass
cratch134110793cratch
crates85736053crates_
craves115825393craves_
craws105723123craws_
crazes174720133crazes_
creak115418433cr_eak
creaks124315963creaks
creaky154911553creaky
cream95721343cr_eam
creams104715253creams
creamy134811363creamy
creased104315583creased
creaser94415723creaser
creases94020963creases
create85126373create
creates95225173creates_
creche13310763creche
creches14313093creches_
cred76530883cr_e_d
credal9311673credal
credent10313973credent
credit9315193credit
credo84815563cr_edo
credos94612843credos
creedal1037093creedal
creeled104012013creeled
creeped12329713creeped
creeper11339973creeper
creepie1137483creepie
creeshing1536243creeshing
creme94319323cr_eme
crenel84213063crenel
crenels93711013crenels
crenshaw1642423crenshaw
creole8913723creole
creoles9913323creoles_
creosol946043creosol
crepe95520723cr_epe
creped114115703creped
crepey135110933crepey
crepiest12310383crepiest
crepon1039933crepon
crept95125893cr_ept
crepy124812703cr_epy
cresol8310203cresol
cresses94219813cresses
cresset93319943cresset
crests85218703crests
cresyl1135133cresyl
cretic102816283cretic
cretin82917913cretin
crew96122673cr_e_w
crewed125316553crewed
crewel114310473crewel
crewels12438483crewels
crewless1335403crewless
cribs94516743cribs_
cried84624283crie_d
crier74724463crie_r
criers83918583criers
crimes105521583crimes_
cripes105120873cripes_
cris66233433cr_is_
crises84529433crises
crisp95014623cr_isp
crissa837623crissa
crits75527573crits_
crocs95722433crocs_
crones84729243crones_
cronish12310863cronish
crops96125233crops_
crores86121163crores_
cross75124503cr_oss
crosse85216303crosse
crotch133410083crotch
crouch133910203crouch
crouse84619363crouse
crows105727313crows_
crozes174417663crozes_
cruces105117543cruces_
crudes96218623crudes_
crudest104510333crudest
cruds85815853cruds_
cruel74815903crue_l
cruelest1059183cruelest
cruet74831843crue_t
cruets85314953cruets
cruise84314043cruise
crunch13349503crunch
crus65828483cr_us_
cruse75726103cr_use
cruses88127713cruses
cruset84425093cruset
crust75827663cr_ust
crutch13408243crutch
cruxes154911563cruxes_
crwth1337483cr_wth
crwths1433433crwths
cubes95028163cubes_
cues65438983c_ues_
cuish10313173c_uish
cukes115422093cukes_
cureless10319703cureless
curers84923183curers_
cures75645433cures_
curets84922343curets_
curies84934023curies_
currish1238353currish
curses85328273curses_
curtest9713963curtest
curtesy1265833curtesy
curves114619283curves_
cutes79438313cutes_
cutest85820143cutest
cutesy114810733cutesy
cuvees1139373cuvees_
cyeses11510123cyeses
cymes1210118923cymes_
deash95617243_deash
decrees102513123decrees_
dees56356633_dees_
dree56638323dree__
dreed75222843dree_d
dregs76114863dregs_
dreich12377723dreich
dreigh11246443dreigh
dreks105714743dreks_
drench12369593drench
dress65319833dr_ess
dressy10518143dressy
drest65530343dr_est
driegh11254563driegh
dries64733673dries_
driest74722753driest
dryest104811123dryest
dryish1336323dryish
enmesh1134893enmesh
epees75219833epees_
ernes55224813ernes_
erses55826803erses_
fees76450603_fees_
feres86038183feres_
fleech14367343fleech
flees85828753flees_
flesh115013743_flesh
free75940183free__
freed95223543free_d
freely12310953freely
freer86021243free_r
freers94717303freers
freesia1046323freesia
freeze18349513freeze
french143511213french
freres94716173freres_
frets85523403frets_
fries85535603fries_
froes86126693froes_
frosh115713403fr_osh
gees55647883_gees_
geese64316003_geese
geest64829613_geest
ghees95215553ghees_
glees65027593glees_
grease75416233grease
greasy10419463greasy
grebes93813613grebes_
gree56641563gree__
greed75125693gree_d
greeds84314283greeds
greedy11518843greedy
greek105915943gree_k
green65522143gree_n
greenish1247073greenish
greens75716873greens
greenth11116723greenth
greeny104811453greeny
greet65835323gree_t
greets75117423greets
greyest11348343greyest
greyish1435173greyish
greys96614853greys_
grues65721963grues_
heres86245903heres_
heresy125011233heresy
hirees95117293hirees_
immesh1334103immesh
inmesh1134853inmesh
ireless72312243ireless
ires45639283ir_es_
jees115938543_jees_
knees95114873knees_
kreep114610413kree_p
kreeps12427413kreeps
krewes1337923krewes_
larees65323113larees_
leash85519213_leash
leech104913213_leech
lees45455883_lees_
mensh105413553_mensh
meres75143573meres_
merest84725113merest
mesh96823003__mesh
ogees65119143ogees_
ogreish1134673ogreish
ores46056683or_es_
orles55326213orles_
pees65257373_pees_
peres76246643peres_
perish114619063perish
preach133613923preach
precess11310863precess
pree67044733pree__
preed85128113pree_d
preen75925053pree_n
preens85020113preens
preps96220693preps_
presa74319043pr_esa
prese75228383pr_ese
preset84430983preset
press75425953pr_ess
prest75736353pr_est
pretest9517633pretest
prewash1535213prewash
prexes154915943prexes_
preys105717783preys_
prezes173614693prezes_
pries74339533pries_
priest84125423priest
purees84721683purees_
rash76039933_r_ash
reach105123883_reach
rebs65733563_rebs_
recess8314263_recess
recs65734183_recs_
redes65139123_redes_
reds56042863_reds_
ree37974073_ree__
reecho11318653_reecho
reechy14367823_reechy
reed55549623_ree_d
reeds65430903_reeds
reedy910020283_reedy
reef74938213_ree_f
reefs85121663_reefs
reefy114217703_reefy
reek85232523_ree_k
reeks94124033_reeks
reeky125416263_reeky
reel45240533_ree_l
reels55333263_reels
reests64618893_reests
reeve84121323_reeve
refresh1335453_refresh
refs75732243_refs_
reges65628783_reges_
regs55436573_regs_
rehash1237433_rehash
reis45343233_reis_
relish93916953_relish
rems66237723_rems_
renest64529713_renest
reps65937953_reps_
res35565043_r_es_
resee54336333_resee
reset55051863_reset
resew84519503_resew
rest46459843_r_est
retch104818303_retch
retest64028453_retest
rets45352563_rets_
reuse56025363_reuse
revest94623603_revest
revs75027053_revs_
rewash1237673_rewash
rexes124526953_rexes_
roes45954133_roes_
rues46044483_rues_
rush76628183_r_ush
ryes75529353_ryes_
sarees65329943sarees_
scree720031703scree__
screechy1842763screechy
screed95718923scree_d
screeds106210283screeds
screen85216013scree_n
screens95212173screens
screws115513883screws_
scries85226823scries_
sees45361053_sees_
seres55448893seres_
serest64831613serest
sirees64624583sirees_
skees95023123skees_
skreegh15182643skreegh
speech1347563speech
sprees85620643sprees_
tees45353583_tees_
teeth87315853_teeth
threes97117323threes_
thresh12276863thresh
trash86119763tr_ash
tree47745813tree__
treed65626733tree_d
treen55622753tree_n
treens65317873treens
trefah1235093trefah
treks96016853treks_
trench114211613trench
tres46542903tr_es_
tress55423163tr_ess
tressy9448553tressy
trets55928023trets_
trews86118893trews_
treys85018213treys_
tries55742813tries_
trues54925323trues_
truest64816193truest
tyees86019453tyees_
unmesh1145793unmesh
ureas55826013ureas_
urease64516993urease
urges64619913urges_
vees75439433_vees_
wees76249123_wees_
weest85026773_weest
welsh113110363_welsh
wreath124111193wreath
wrench14439353wrench
wrens85016243wrens_
wrest84925433wr_est
wretch14326533wretch
wries85827743wries_
wriest94419713wriest
wryest12429113wryest
zees136331893_zees_

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165267.97014142.5
3Display Results5265260.1733040.5
 (SQL Overall)1786915268.28321573.2
 
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.