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

294 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
ocreate9371174(None) 
cocreate122611811cocreate
create85126381_create
ocreae83310271ocrea_e
acerate92818912acerate
acreage1037842acreage
aureate72515282aureate
cerate84829462_cerate
cocreated142710092cocreated
cocreates132611882cocreates
cordate10315222cordate
corelate10516012corelate
crate76537402_cr_ate
crease85519572_crease
created104323452_created
creates95225202_creates
cremate113816182_cremate
crenate93317112_crenate
increate10312202increate
ochreae12295082ochrea_e
ocrea73311822ocrea__
octette946422octette
oleate6318882o_leate
operate9615732operate
orate55133302o_r_ate
ornate6315142o_rnate
overate10620962overate
procreate1348132procreate
recreate10313602recreate
uncreate10311352uncreate
accrete1137843accre_te
acerated113113983acerated
acerbate1247533acerbate
acervate1336983acervate
acetate92514753acetate
acierate10311813acierate
acreages1138373acreages
acrylate1347693acrylate
actuate9311443actuate
acuate8315633ac_uate
aculeate1039923aculeate
acylate12310533acylate
aerate64830553aer_ate
airdate8311323airdate
arcuate9311963arcuate
areae55229743_area_e
arete56031353_are_te
aurate64426473aur_ate
barbate11314543barbate
berate84729023ber_ate
bereave1258353bereave
borate85026153bor_ate
breath113916263_breath
breathe123711843_breathe
burette939853burette
bursate94111203bursate
carate84734003_carate
caseate9314783caseate
cate66254603_c__ate
cease75227653_c_ease
cerated103922473_cerated
cerates95428253_cerates
cerite84724873_cerite
cete64934783_c_e_te
cheat105732453_cheat_
cheated134416343_cheated
cheater124816963_cheater
cheats114519543_cheats
chelate122914893_chelate
cirrate92413493cirrate
cleat76335063_cleat_
cleated103417843_cleated
cleats84919313_cleats
cleave114212513_cleave
cochleate1645683cochleate
cocreator1346963cocreator
cognate10312203cognate
collate92919683collate
comate104124843_comate
concrete12411083concre_te
conepate12712533conepate
connate9315753connate
copemate1439993copemate
cordage11310063cordage
cordite10315263cordite
corelated12411823corelated
corelates11314863corelates
corkage1438373corkage
cornute939643cornute
coronate103018213coronate
corotate102813933corotate
corrade101111043corrade
correlate1149043correlate
corsage1039803corsage
corvette1338093corvette
costate94019273costate
crake114823523_cr_ake
crane75331603_cr_ane
crape96128443_cr_ape
crated94827773_cr_ated
crater85026643_cr_ater
crates85736063_cr_ates
crave105626313_cr_ave
craze165221463_cr_aze
creak115418433_crea_k
creaked143413233_creaked
creaks124315963_creaks
creaky154911553_creaky
cream95721353_crea_m
creamed123913713_creamed
creamer113714093_creamer
creams104715253_creams
creamy134811363_creamy
creased104315583_creased
creaser94415733_creaser
creases94020963_creases
creasy114612303_creasy
creatin93618133_creatin
creatine103417413_creatine
creative132812803_creative
creator93714443_creator
creature1038733_creature
creche13310763_creche
creese84014333_creese
cremated133412963_cremated
cremates124216003_cremates
creme94319323_cre_me
crenated113013913_crenated
creole8913733_creole
crepe95520723_cre_pe
crept95125893_crept_
crest74632693_crest_
crested103416533_crested
crests85218703_crests
crewmate15405633_crewmate
croute84617273_croute
cuneate9311723cuneate
curate85226243_curate
curette939783curette
curtate9312643curtate
decrease1136563decrease
derate74531233der_ate
ergate7315143_ergate
excrete1667163excre_te
fermate122813003fermate
ferrate103014043ferrate
foredate12310913foredate
formate123115093formate
foveate1338363foveate
furcate12310453furcate
galeate83916783galeate
grate64932883_gr_ate
grease75416233_grease
great66034243_great_
greaten83610643_greaten
greater84416493_greater
greats76318393_greats
greave104611493_greave
gyrate104912523gyr_ate
hereat93527413hereat_
ideate7313683_ideate
increase1066453increase
irate55627983_ir_ate
iterate71119113iterate
jockette2165033jockette
karate105320923kar_ate
lacerate102214703lacerate
laureate888023laureate
lineate7815153lineate
locate83919843loc__ate
loculate101011403loculate
lyrate94112103lyr_ate
macerate122314073macerate
maleate94117543maleate
miscreate1348893miscreate
moderate11710993moderate
muriate9313363muriate
narrate7313493narrate
nervate1039523nervate
nucleate1048673nucleate
obcordate1442853obcordate
oblate82214743o_blate
obovate1235463obovate
obviate1235783obviate
ocean71212963oc_ea_n
oceans81211003oc_eans
ocellate1037863ocellate
ochrea11316643ochrea__
ocicat101412813ocicat_
ocicats11137413ocicats
octane81411633oc_tane
octave11157343oc_tave
octet7324063octe_t_
octets839403octe_ts
octettes1045533octettes
odonate848403odonate
oleates7417833o_leates
operated11512223operated
operates10515413operates
opiate8513463o_piate
orated74221503o_r_ated
orates64328613o_r_ates
oread64619603o_rea_d
oreads73915773o_reads
oreide7311673o_reide
orgeat7515033orgeat_
orgeats838353orgeats
osculate101010613osculate
outate62923403o_utate
outdate83016423outdate
outeat62824533outeat_
outeaten8310423outeaten
outeats72215703outeats
outrate72323183outrate
ovate84214393o__vate
overage11514053overage
overawe13511463overawe
overeat102620323overeat_
overeaten12312783overeaten
overeater12312483overeater
overeats112415263overeats
overhate14312793overhate
overlate11716283overlate
overrate11615693overrate
ovulate1039453ovulate
oxalate1457623oxalate
oxidate1537023oxidate
ozonate1646863ozonate
paleate94120003paleate
permeate12311613permeate
picrate112014143picr_ate
pileate93815923pileate
pirate82322883pir_ate
prate75135983_pr_ate
predate10616893_predate
prelate9519693_prelate
procreated1546443procreated
procreates1448153procreates
rate45458763__r_ate
reata54225393__reata
reave84528023__reave
rebate84424113__rebate
recrate92621663recr_ate
recreated12412533recreated
recreates11313363recreates
redate74124683__redate
relate64033633__relate
remate84428683__remate
rente54733783__rente
rete44944133__re_te
roseate7613453roseate
scrape105917573scr_ape
screak125311063screa_k
screaked15246983screaked
screaks13469363screaks
screaky16436223screaky
scream104814253screa_m
screamed13277603screamed
screamer12267883screamer
screams114810623screams
scree720031713scre__e
scutate9310323scutate
secrete9311073secre_te
serenate81914883serenate
seriate73722473seriate
serrate73017543serrate
sorbate9311733sorbate
strette7310763strette
striate74218953striate
syrette1037183syrette
terete6319333tere_te
ternate7415483ternate
threat95020463threat_
threated1259203threated
threaten1146303threaten
threats104311673threats
toccate1138773toc_cate
tolerate8312323tolerate
treat56240353_treat_
treated83618703_treated
treater74219833_treater
treats64821693_treats
treaty94414353_treaty
ulcerate1039733ulcerate
uncrate9415953uncr_ate
uncreated12312303uncreated
uncreates11310433uncreates
uprate83916543upr_ate
urate55432163_ur_ate
urease64516993_urease
variate101316433variate
virgate1138733virgate
wreath124111193_wreath
wreathe13339053_wreathe

Search took 7 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.436409841.7
2DLD Change Limit1340272946.29621287.6
3Display Results2942940.1262333.3
 (SQL Overall)1786912946.85826055.8
 
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.