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

217 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
bereave125835(None) 
bereaved1446401bereaved
bereaver1346671bereaver
bereaves1338271bereaves
behave14209012be_have
berake124216082ber_ake
berate84729022ber_ate
bereavers1446122bereavers
brave104925502b_r_ave
breve105317052b_re_ve
deleave1147722deleave
greave104611492_greave
reave84528022__reave
reweave1336772reweave
acreage1037833acreage
aerate64830553aer_ate
airwave1344433airwave
areae55229743_area_e
aureate72515283aureate
barbate11314543barbate
barege94713543bare_ge
barrage10710843barrage
barware12610703barware
beaver114819253b__eaver
became123213163be_came
bedeafen1443343bedeafen
bedmate1239433bedmate
bedrape1277693bedrape
beebee10313063be_ebee
beehive1554033beehive
beetle8311673be_etle
beeves114615043be_e_ves
begaze1838333be_gaze
behaved16176683be_haved
behaver15206723be_haver
behaves15198523be_haves
behead1239923behea_d
beheaded1536373beheaded
beheader1436043beheader
beheads1338523beheads
behoove1553773behoove
behove14207203be_hove
beldame1237233beldame
beleap10410283belea_p
beleaped1336103beleaped
beleaps1138053beleaps
beleapt11310253beleapt
believe12519773believe
belive115415303be_live
bemean10410683bemea_n
bemeaned1335783bemeaned
bemeans1148733bemeans
bename103316073be_name
beneath1236973beneath
beraked144312433ber_aked
berakes134815773ber_akes
berated104422133ber_ated
berates94126873ber_ates
berceuse1243433berceuse
berdache1644033berdache
bereaving1537573bereaving
bereft114317303bere_ft
beret74946363bere__t
berets85822523bere_ts
beretta938463beretta
bergere1068913bergere
berhyme1743813berhyme
berime105317333ber_ime
berline93716853berline
berme96022943ber__me
beshame1447483beshame
beslaved1435023beslaved
bespake15436963bespake
betake124512703be_take
beverage1445143beverage
beware11313713be_ware
beweary1536223beweary
bireme10310143bire_me
borage93917013bor_age
borane84620213bor_ane
borate85026153bor_ate
boreal84817213borea_l
boreas85421733borea_s
boreases10310253boreases
brace95629273b_r_ace
brae65639113b_r_a_e
brake116025343b_r_ake
brava106414793b_r_ava
braved124817443b_r_aved
braver114719043b_r_aver
braves115524083b_r_aves
bravi104715753b_r_avi
bravo105214343b_r_avo
braze165423453b_r_aze
breach134213723b_reach
bread85523113b_rea_d
breaded115014063b_readed
breads95419203b_reads
bready124511183b_ready
break115319403b_rea_k
breaker133912923b_reaker
breaks124816423b_reaks
bream95121813b_rea_m
breamed124011593b_reamed
breams104815043b_reams
breast8319633b_reast
breath113916263b_reath
breathe123711843b_reathe
brede85520503b_re_de
bree67241263b_re__e
breeze17298963b_reeze
breves115516423b_re_ves
brevet115717333b_re_vet
brewage1347183brewage
bureau8712523burea_u
bureaus979293bureaus
bureaux1664593bureaux
burette939853burette
burgage1136633burgage
burgrave1443113burgrave
bursae84515603bursa_e
bursate94111203bursate
cerate84829463cer_ate
cereal8315833cerea_l
cereals9313173cereals
cleave114212513_cleave
crave105626313_cr_ave
crease85519573_crease
create85126383_create
deave95022333__deave
decease1049523decease
deceive1337813deceive
decrease1136563decrease
degrease1045413degrease
deleaved1346573deleaved
deleaves1248063deleaves
deprave1337073deprave
derate74531233der_ate
derive103817043der_ive
deserve11108703deserve
drave95219273_dr_ave
eave75733583___eave
erase54925493_er_ase
ergate7315143_ergate
feriae95618603feria_e
fermate122813003fermate
ferrate103014043ferrate
forgave1435853forgave
germane1049663germane
grave94624873_gr_ave
grease75416233_grease
greaved12408913_greaved
greaves113311443_greaves
heave114521813__heave
herbage1337003herbage
hereat93527413herea_t
hermae115314473herma_e
inweave1344723inweave
keeve124512123ke_e_ve
leave84723723__leave
nervate1039523nervate
nerve86617373ner__ve
ocreae83310273ocrea_e
ocreate93711743ocreate
oversave14310493oversave
pareve114613013pare_ve
peerage1089803peerage
peeve104915253pe_e_ve
percale11314093percale
perceive1546973perceive
perea75026443perea__
permease1246503permease
permeate12311613permeate
pervade1337023pervade
preaver121011613_preaver
prepave14228873prepave
rave75542093__r_ave
reaved104523923__reaved
reaver94524733__reaver
reaves94127573__reaves
receive1239733receive
recreate10313603recreate
reeve84121323__reeve
regave104713383re_gave
reive85522943__reive
release7312763release
releve95116403rele_ve
repave114813873re_pave
reread71715433rerea_d
rereads81512293rereads
reserve101011203reserve
reshave1338603reshave
reweaved1535953reweaved
reweaves1436603reweaves
serape84818413ser_ape
serenade9218343serenade
serenate81914883serenate
serene63522353sere_ne
serfage1138403serfage
seriate73722473seriate
serrate73017543serrate
serve85425963ser__ve
sheave124514003_sheave
sleave94714153_sleave
terete6319333tere_te
ternate7415483ternate
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
thrave126010273thr_ave
trave85223033_tr_ave
unreeve10176763unreeve
unweave1336363unweave
upheave1544023upheave
urease64516993_urease
verve115417723ver__ve
weave115218533__weave

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272177.22018563.3
3Display Results2172170.0762855.3
 (SQL Overall)1786912177.45223978.9
 
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.