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

220 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
decerned123726(None) 
secerned1136101secerned
deceased1247712deceased
deceived1535892deceived
decern91310952decern__
decerns10119052decern_s
declined123910882declined
decreed112710252dec_reed
decried112612852dec_ried
decurved1534842decurved
deferred13106362deferred
degermed1335452degermed
dehorned1345682dehorned
demeaned1237282demeaned
demerged13157602demerged
depermed1436452depermed
deserted101012202deserted
deserved13108132deserved
deterged11127922deterged
deterred10137802deterred
deveined1336672deveined
discerned1347862discerned
acorned10238273_acorned
beckoned1735783beckoned
becursed1335583becursed
bemeaned1335783bemeaned
caverned1436163caverned
cered85227443__cer_ed
concerned1438643concerned
corned95224523__corned
dackered16116893dacker_ed
darned85018483d__arned
davened124610073dave_ned
deaconed1237493deaconed
deadened1137233deadened
deaerated11311113deaerated
deafened1335853deafened
deaired9411533deair_ed
deaned84620453d__eaned
debarked16175823debarked
debarred12165633debarred
debeaked1634613debeaked
debearded1443373debearded
deboned113411633de_boned
decamped1634963decamped
decane93818873dec_ane_
decanes103118913dec_anes
decanted122310493decanted
decare93919153decar_e_
decares102818533decar_es
decayed14309333dec_ayed
decease1049523decease_
deceases11410153deceases
decedent12310213decedent
deceive1337813deceive_
deceiver1436233deceiver
deceives1437903deceives
decency1537453dece_ncy
decennia1144223decennia
decent94023703dece_n_t
decenter112412163decenter
decentred13236233decentred
decerning1337293decerning
decided124312423dec_ided
decked145217623dec__ked
declared1248743declared
declawed1545923declawed
decline103716613decline_
decliner113710843decliner
declines113315803declines
decocted1437683decocted
decoded123212383dec_oded
decorated13312203decorated
decoyed14358333dec_oyed
decreased1345453decreased
decree93117783dec_r_ee
decreer10269123dec_reer
decrees102513123dec_rees
decrier102713553dec_rier
decries103319803dec_ries
decrowned1663653decrowned
decupled1494983decupled
decuries11312223decuries
decurve1335583decurve_
decurves1435863decurves
deeded94615543de_e_ded
deemed104713063de_e_med
deepened1235663deepened
deerweed1344183de_erweed
defeated132812163defeated
defected15289973defected
defenced1537203defenced
defend113910493defe_n_d
defended1437223defended
defensed1336223defensed
deferent122712873deferent
deferrer12135593deferrer
defined123813823de_fined
deforced15247373deforced
deformed15248263deformed
degreed10258883de_greed
dehorner1235523dehorner
dehorted1357303dehorted
deigned1037503de_igned
dejected19307593dejected
dejeuner1682933dejeuner
deleaded1148333deleaded
deleaved1346573deleaved
deleted93314913dele_ted
demarked16187223demarked
demented12311273demented
demerge11168023demerge_
demerger12127373demerger
demerges12129503demerges
demerited1339073demerited
demesne1035573demesne_
demesnes1137083demesnes
demurred1234933demurred
denned84215633d__enned
departed1238823departed
depend103510923depe_n_d
depended1337983depended
deplaned1238663deplaned
deponed113712873de_poned
deported1249703deported
descend11248153desce_n_d
descended1446283descended
descried1248073descried
deserter91211603deserter
deserve11108703deserve_
deserver12118383deserver
deserves12109893deserves
desexed1636183dese_xed
designed1136943designed
desired9311983desir_ed
desorbed1236443desorbed
destined103312453destined
detained103111643detained
detected12289733detected
deterge9118463deterge_
deterger10147593deterger
deterges101510093deterges
determined1455823determined
deterrer9137013deterrer
detested10279623detested
dethroned1445073dethroned
develed123611933deve_led
devested13239133devested
dewormed15236223dewormed
dickered16117533dicker_ed
discerner1246943discerner
diverged14256883diverged
diverted13199583diverted
dizened18267333dize_ned
dovened12389063dove_ned
dowered122811553dower_ed
dozened18377453doze_ned
durned84113173d__urned
earned74818333_e_arned
emerged11158213_emerged
emersed10138513_emersed
eterne6311723_eterne_
evened101010313_eve_ned
everted112711853_everted
exerted152210053_exerted
fevered14339723fever_ed
governed1335193governed
interned93016653interned
jeered143912793je_er_ed
keened114013633ke_e_ned
kerned114112933__kerned
learned8329303le_arned
lechered1437523lecher_ed
leered73816223le_er_ed
levered114212303lever_ed
lucerne945753lucerne_
lucernes1046363lucernes
metered103514013meter_ed
peened94318163pe_e_ned
peered93819493pe_er_ed
petered103314973peter_ed
recaned102817203rec_aned
receded112713043rece_ded
received1437983received
recessed1139713recessed
reckoned1546953reckoned
recleaned1236583recleaned
reclined113613603reclined
recoined113614423recoined
reconned113610653reconned
recorded122511063recorded
recorked15239853recorked
recurred1137093recurred
recurved1436493recurved
reearned948883reearned
refereed12149693refereed
referred1297833referred
relearned1035633relearned
remerged12149173remerged
reperked15177793reperked
reserved121010583reserved
returned9459133returned
reverbed14269223reverbed
revered112819333rever_ed
reverend12288853reverend
reversed122711613reversed
reverted122714713reverted
rezeroed1835993rezeroed
scorned10229953_scorned
seceded11319203sece_ded
secern81010223secern__
secerns987733secern_s
secreted1138633secreted
secured1059723secur_ed
severed113513863sever_ed
sewered112911243sewer_ed
ulcered1037973ulcer_ed
veered103612743ve_er_ed
weened104013733we_e_ned
yearned11327373ye_arned

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622206.95621012.4
3Display Results2202200.0932365.6
 (SQL Overall)1786912207.46923924.4
 
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.