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

348 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
ocreae8331027(None) 
ochreae12295081ochreae
ocrea73311821ocrea_
ocreate93711741ocreate
acreage1037842acreage
areae55229742_areae
cocreate122611812cocreate
creak115418432_creak
cream95721352_cream
crease85519572_crease
create85126382_create
creme94319322_creme
crepe95520722_crepe
ocean71212962oc_ean
ochrea11316642ochrea_
oread64619602o_read
screak125311062screak
scream104814252scream
scree720031712scre_e
accede1138303accede
accrete1137843accrete
acerate92818913acerate
achene11313813achene
ackee115825373acke_e
acre67330773acr__e
acreages1138373acreages
acred87126353acre_d
acres76327763acre_s
agree65226033agre_e
aortae65115473aortae
area45843393_area_
areal55928733_areal
areas55935773_areas
arene55329413_arene
arete56031353_arete
arrear6310253arrear
aurae54128113aur_ae
aureate72515283aureate
barege94713543barege
bereave1258353bereave
bireme10310143bireme
boreal84817213boreal
boreas85421733boreas
brae65639113_br_ae
bread85523113_bread
break115319403_break
bream95121813_bream
brede85520503_brede
bree67241263_bre_e
breve105317053_breve
bureau8712523bureau
bursae84515603bursae
cease75227653_c_ease
cede74928773_c_ede
cee55952703_c_e_e
cepe84926653_c_epe
cerate84829463_cerate
cere66741473_c_ere
cereal8315833cereal
cete64934783_c_ete
cheap126915943_cheap
cheat105732453_cheat
chelae113614603_chelae
clean75420413_clean
clear76219053_clear
cleat76335063_cleat
cleave114212513_cleave
clepe94617383_clepe
cochleae1544643cochleae
cockeye1867223cockeye
cocreated142710093cocreated
cocreates132611883cocreates
coerce10310403coerce
cohead123811123cohead
cohere112716993cohere
colead94114643colead
comae97128423_comae
concrete12411083concrete
cooee74531023cooe_e
coral76033453cor_al
corban10314693corban
corbie103618203corbie
cordage11310063cordage
cordate10315223cordate
core67263113cor__e
cored85044223core_d
corelate10516013corelate
corer75538873core_r
corers85231073corers
cores76361853core_s
coria75828323coria_
corkage1438373corkage
cornea84018933cornea_
corneal94414503corneal
corneas94717003corneas
coronae94214893coronae
corpse104013403corpse
corrade101111043corrade
corral83616253corral
corrie83621233corrie
corsac10410173corsac
corsage1039803corsage
corse75036183cor_se
cortege1098953cortege
corvee114320093corvee
costae85319683costae
coteau8311083coteau
cottae84615703cottae
coxae146115183_coxae
craal74117753_craal
crab85727673_cr_ab
crag75625303_cr_ag
crake114823523_crake
cram85635493_cr_am
crane75331603_crane
crap85731843_cr_ap
crape96128443_crape
crate76537403_crate
crave105626313_crave
craw97725263_cr_aw
craze165221463_craze
creaked143413233_creaked
creaks124315963_creaks
creaky154911553_creaky
creamed123913713_creamed
creamer113714093_creamer
creams104715253_creams
creamy134811363_creamy
creased104315583_creased
creaser94415743_creaser
creases94020963_creases
creasy114612303_creasy
created104323453_created
creates95225203_creates
creche13310763_creche
cred76530883_cre_d
credal9311673_credal
credo84815573_credo
creds85418773_creds
creed85727393_creed
creek114917393_creek
creel75121483_creel
creep95218103_creep
creese84014333_creese
cremate113816183_cremate
cremes104517993_cremes
crenate93317113_crenate
crenel84213063_crenel
creole8913733_creole
creped114115703_creped
crepes105419343_crepes
crepey135110933_crepey
crept95125893_crept
crepy124812703_crepy
cress75022833_cress
crest74632693_crest
crew96122683_cre_w
crewed125316563_crewed
crewel114310483_crewel
crews105917503_crews
crime94822693_crime
cripe95521143_cripe
croak115216633_croak
crone75231333_crone
crore74922873_crore
croze164719453_croze
crude86018573_crude
cruse75726103_cruse
curiae84518373curiae
cymae126713013_cymae
decrease1136563decrease
decree93117783decre_e
dread74419023_dread
dream85120393_dream
drear65016903_drear
dree56638323_dre_e
eocene8311613eoc_ene
excrete1667163excrete
feriae95618603feriae
foveae1237563foveae
frae75330473_fr_ae
freak125115243_freak
free75940183_fre_e
frere85617723_frere
galeae74717453galeae
grease75416233_grease
great66034243_great
greave104611493_greave
grebe85114943_grebe
gree56641563_gre_e
gyrene10227243gyrene
hereat93527413hereat
hermae115314473hermae
hiree85427803hire_e
increase1066453increase
increate10312203increate
irreal657833irreal
krewe1238193_krewe
laree56036293lare_e
larvae938843larvae
loreal63814313loreal
morae75831193mor_ae
morceau1145573morceau
oared65030653oare_d
obeah1038993o_beah
obese75212423o_bese
oca56731733oc__a_
ocas66729633oc__as
oceans81211003oc_eans
ocher104516103oche_r
ochered132610283ochered
ochers113915303ochers
ochery14319443ochery
ochone11311293ochone
ochre103411593oc_hre
ochred12328003ochre_d
ochres113510833ochre_s
ocicat101412813ocicat
ocker113915753ocke_r
ockers123813903ockers
octad81510653oc_tad
octal71214723oc_tal
octan71313483oc_tan
octane81411633octane
octave11157343octave
octet7324063octe_t
octets839403octets
octette946423octette
ocular8610133ocular
odea56224573o_dea_
ogee57629883o_ge_e
ogre56320743ogr__e
ogres65818633ogre_s
ogress7529503ogress
okra86413573okr_a_
okras94410973okr_as
olea46532723o_lea_
oleate6318883o_leate
oorie53026363oor_ie
opera7313573opera_
operas8312453operas
operate9615733operate
ora37250833o_r_a_
orad56031693o_r_ad
oral47638123o_r_al
orate55133303o_rate
orca65522773o_rca_
orcas75918623o_rcas
orcein838183orcein
ordeal779253ordeal
ore36661833o_r__e
oreads73915773o_reads
oreide7311673o_reide
ores46056683o_re_s
organ6915393o_rgan
orgeat7515033orgeat
orle45630463o_r_le
ornate6315143o_rnate
orra46120723o_rra_
orrery936783orrery
orrice81410163orrice
osteal6312963osteal
ourebi837173ourebi
ourie54027303our_ie
outeat62824533outeat
outread82811093outread
overage11514053overage
overate10620963overate
overawe13511463overawe
overeat102620323overeat
oxeye1536913o_xeye
paleae84820293paleae
parae76335703par_ae
pareve114613013pareve
perea75026443perea_
phreak1536153phreak
pree67044733_pre_e
prese75228383_prese
procreate1348143procreate
puree74632843pure_e
pyrene113210733pyrene
read55942533__read
real45750293__real
ream65841613__ream
reap65934743__reap
rear45644553__rear
reave84528023__reave
recreate10313603recreate
rede55037673__rede
ree37974073__re_e
reread71715433reread
rete44944133__rete
saree55044663sare_e
scene77220573sc_ene
scheme1379633scheme
sclerae937933sclerae
scoriae9310903scoriae
scrag85916173scr_ag
scram910621623scr_am
scrap97120403scr_ap
scrape105917573scrape
screaked15246983screaked
screaks13469363screaks
screaky16436223screaky
screamed13277603screamed
screamer12267883screamer
screams114810623screams
screed95718933screed
screen85216023screen
screes85023973screes
screw109318543scre_w
screwed135710663screwed
screwer124410073screwer
screws115513893screws
screwy14659463screwy
scribe104613533scribe
scrieve12448333scrieve
scrive115414943scrive
secrete9311073secrete
serene63522353serene
siree55238813sire_e
sockeye1666413sockeye
soiree62919483soire_e
spread9312533spread
spree74830863spre_e
streak104613623streak
stream84717293stream
striae65422273striae
terete6319333terete
terrae62915213terrae
thread105011093thread
threap11569663threap
threat95020463threat
three87526913thre_e
tread64821703_tread
treat56240353_treat
tree47745813_tre_e
uncreate10311353uncreate
unread73412673unread
unreal64414453unreal
uprear8168793uprear
urea46528063_urea_
ureal56722683_ureal
ureas55826013_ureas
urease64516993_urease
ursae55214453_ursae
wreak125513273_wreak
zoeae144412483_zoeae

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 Filter1786911127160.373479064.3
2DLD Change Limit1127163489.00012524.0
3Display Results3483480.1103163.6
 (SQL Overall)1786913489.48318843.3
 
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.