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

208 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
deserved1310813(None) 
deserted101012201deserted
deserve11108701deserve_
deserver12118381deserver
deserves12109891deserves
reserved121010581reserved
deceived1535892deceived
decerned1237262decerned
decurved1534842decurved
deferred13106362deferred
degermed1335452degermed
deleaved1346572deleaved
demerged13157602demerged
depermed1436452depermed
descried1248082descried
deserter91211602deserter
deservedly1852612deservedly
deservers13107292deservers
desexed1636182dese_xed
desired9311982desir_ed
desorbed1236442desorbed
deterged11127922deterged
deterred10137802deterred
disserved14107002disserved
observed1444382observed
preserved15107562preserved
reserve101011202reserve_
reserver11119632reserver
reserves111011982reserves
served104616812__served
undeserved1544162undeserved
unserved12410232unserved
asserted957913asserted
bereaved1446403bereaved
beseemed1334863beseemed
beslaved1435023beslaved
conserved1538853conserved
deaerated11311123deaerated
deaired9411533deair_ed
deaved114916553d__eaved
debarked16175833debarked
debarred12165643debarred
debeaked1634613debeaked
debearded1443373debearded
deceased1247723deceased
deceive1337813deceive_
deceiver1436233deceiver
deceives1437903deceives
decreed112710263de_creed
decried112612863de_cried
decurve1335583decurve_
decurves1435863decurves
deeded94615543de_e_ded
deemed104713063de_e_med
deerweed1344193de_erweed
defeated132812163defeated
defected15289973defected
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferrer12135593deferrer
deforced15247373deforced
deformed15248263deformed
degreed10258883de_greed
dehorned1345683dehorned
dehorted1357303dehorted
dejected19307593dejected
deleaded1148333deleaded
deleave1147723deleave_
deleaves1248063deleaves
deleted93314913dele_ted
delved114112753d__elved
demarked16187223demarked
demeaned1237283demeaned
demented12311273demented
demerge11168023demerge_
demerger12127373demerger
demerges12129503demerges
demerited1339073demerited
demurred1234933demurred
denervated1545113denervated
departed1238823departed
depended1337983depended
deported1249703deported
depraved1535543depraved
deprived1546463deprived
derived123912763de_rived
desalted1038313desalted
desanded11227453desanded
descended1446283descended
described1544953described
descrier1157623descrier
descries11311923descries
desecrated1447953desecrated
desert72725493deser__t
deserters10129983deserters
desertic1147743desertic
deserts82513053deser_ts
deserving1497903deserving
desexes1537833dese_xes
designed1136943designed
desilver12286503desilver
desire7415303desir_e_
desirer8310783desir_er
desires81316133desir_es
desisted1039783desisted
despised1236933despised
despited1248323despited
destined103312453destined
destrier9311823destrier
destroyed1445083destroyed
detected12289733detected
deterge9118463deterge_
deterger10147593deterger
deterges101510093deterges
deterrer9137013deterrer
detested10279623detested
deveined1336673deveined
develed123611933deve_led
devested13239133devested
devolved16325513devolved
dewormed15236223dewormed
dieseled1035523diese_led
disarmed1238643disarmed
discerned1347863discerned
diseased103011713diseased
dispersed13119783dispersed
disproved16147343disproved
dissaved1337313dissaved
disserted11109813disserted
disserve1287443disserve_
disserves1388063disserves
diverged14256883diverged
diverted13199583diverted
dowered122811553dower_ed
emerged11158213_emerged
emersed10138513_emersed
enserfed1245193enserfed
everted112711853_everted
exerted152210053_exerted
exserted1636213exserted
festered122512113fester_ed
fevered14339723fever_ed
innerved1246293innerved
inserted92413053inserted
jeered143912793je_er_ed
leered73816223le_er_ed
levered114212303lever_ed
meseemed1343963meseemed
metered103514013meter_ed
nerved104111693__nerved
observe1245333observe_
observer1344733observer
observes1346173observes
outserved13136463outserved
peered93819493pe_er_ed
peeved124112893pe_e_ved
pestered112814973pester_ed
petered103314973peter_ed
preserve13108803preserve_
preserver14127013preserver
preserves14109073preserves
received1437983received
recurved1436493recurved
reeved104118713re_e_ved
refereed12149693refereed
referred1297833referred
remerged12149173remerged
reobserved1642403reobserved
reperked15177793reperked
resealed92713973resealed
reseated93220263reseated
resected112514743resected
reseed74823293rese__ed
reseeded1038093reseeded
reseized1839213reseized
resented92716963resented
reservedly1742913reservedly
reservers12138103reservers
reserviced1643753reserviced
resewed113011833rese_wed
reshaved1536873reshaved
resolved12349343resolved
resorbed1138533resorbed
resorted9313493resorted
resurged1038623resurged
resurvey1444823resurvey
reverbed14269223reverbed
revered112819333rever_ed
reversed122711613reversed
reverted122714713reverted
reweaved1535953reweaved
rezeroed1835993rezeroed
secerned1136103secerned
sered65737293__ser_ed
serged84118773__serged
serve85425963__serve_
server94917713__server
serves94423653__serves
severed113513863sever_ed
sewered112911243sewer_ed
subserved1545143subserved
swerved1455703_swerved
underserved1644633underserved
unnerved1248063unnerved
unreserved1443903unreserved
veered103612743ve_er_ed
westered122511873wester_ed

Search took 9 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.436409841.7
2DLD Change Limit1461622087.57619292.8
3Display Results2082080.0802600.0
 (SQL Overall)1786912088.09222082.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.