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

185 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
deprave133707(None) 
depraved1535541depraved
depraver1435411depraver
depraves1436871depraves
deprive1338301deprive
deave95022332de__ave
degrade10229902degrade
deleave1147722deleave
deplane10311412deplane
depravers1534682depravers
deprived1546462deprived
depriver1446292depriver
deprives1438392deprives
depurate1139982depurate
derate74531232de_rate
derive103817042de_rive
drave95219272d__rave
repave114813872rep_ave
reprove122911072reprove
aerate64830553ae_rate
approve14116603approve
bedrape1277693bedrape
behave14209013be_have
berake124216083be_rake
berate84729023be_rate
bereave1258353bereave
brave104925503__brave
cerate84829463ce_rate
crave105626313__crave
deaerate9314173deaerate
dealate83617843dealate
dearie73319813dear_ie
deaved114916553de__aved
deaves105319533de__aves
debase94014473de_base
debate94419193de_bate
debride1138593debride
decade104216163de_cade
decane93818873de_cane
decare93919153de_care
decease1049523decease
deceive1337813deceive
deciare10710663deciare
declare10411223declare
decorate11315193decorate
decrease1136563decrease
decree93117783decr_ee
decurve1335583decurve
deface123113863de_face
defame123212433de_fame
deflate113613943deflate
defrag1136463defra_g
defrags1236193defrags
defraud1243913defraud
defray1337643defra_y
defrayed1635403defrayed
defrayer1534933defrayer
defrays1436113defrays
degage92711383de_gage
degame102713183de_game
deglaze1835583deglaze
degraded12288323degraded
degrader11247913degrader
degrades11269923degrades
degrease1045413degrease
degree82814853degr_ee
dekare112811563de_kare
delate73827753de_late
deleaved1346573deleaved
deleaves1248063deleaves
delve96018263de__lve
dentate8315153dentate
depart94720563dep_art
departed1238823departed
departee1139723departee
departs104310683departs
depilate11311703depilate
deplaned1238663deplaned
deplanes11311213deplanes
deplete103010423deplete
deplore1039483deplore
deplume1255063deplume
depone93616553dep_one
deportee11510353deportee
depose94215763dep_ose
depravedly2051863depravedly
depraving1635973depraving
depravity1842793depravity
deprecate1477433deprecate
depredate1345733depredate
depress10239873depress
deprival1444603deprival
deprivers1545213deprivers
depside1138403depside
depurated1338183depurated
depurates1239823depurates
depute94512303dep_ute
derail74218813de_rail
derange939813de_range
derat65044083de_ra_t
derated93623503de_rated
derates84028893de_rates
derats74625063de_rats
deray95024183de_ra_y
derays105514253de_rays
dere56845903de_r__e
deride84420033de_ride
derived123912763de_rived
deriver114213913de_river
derives114017813de_rives
deserve11108703deserve
desperate12410843desperate
detract101414633detract
detrain8412253detrain
detrude936083detrude
deviate11312713deviate
devolve14316063devolve
diphase1387273diphase
disprove14138193disprove
disrate81418523disrate
dissave1139413dissave
drake104918303d__rake
drape85319633d__rape
drive95318003d__rive
drove95518063d__rove
eave75733583_e__ave
engrave1137133engrave
enrage72715073_enrage
erase54925493_e_rase
ferrate103014043ferrate
grave94624873__grave
heave114521813he__ave
heptane1238363heptane
improve1435963improve
leave84723723le__ave
leprose938543leprose
nerve86617373ne_r_ve
operate9615733operate
outrave102614413outrave
parve109824853__parve
pave96133893__p_ave
peerage1089803peerage
petrale9312623petrale
prase76128753__prase
prate75135983__prate
prepave14228873prep_ave
prove104823193__prove
rave75542093___rave
reave84528023re__ave
recrate92621663recrate
redrive112410563redrive
redrove11249423redrove
reframe1239393reframe
regave104713383re_gave
regrade92612033regrade
regrate82618663regrate
repaved133311133rep_aved
repaves123513653rep_aves
rephrase1346733rephrase
replace113214283replace
replate93420053replate
reprice113212833reprice
reprieve1375443reprieve
reprise92715043reprise
reprobe112310133reprobe
reproved14199473reproved
reprover13229203reprover
reproves132011473reproves
reshave1338603reshave
retrace91417343retrace
reweave1336773reweave
separate10310783separate
septage1078403septage
septate9511873septate
serape84818413se_rape
serrate73017543serrate
serve85425963se_r_ve
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
thrave126010273_thrave
trave85223033__trave
uprate83916543_uprate
verve115417723ve_r_ve
weave115218533we__ave

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.406440125.6
2DLD Change Limit1340271856.04622167.9
3Display Results1851850.0632936.5
 (SQL Overall)1786911856.51527427.6
 
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.