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

201 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
dejected1930759(None) 
defected15289971defected
detected12289731detected
ejected17297651_ejected
rejected182710111rejected
decocted1437692decocted
deducted1356242deducted
defeated132812162defeated
defecated1637492defecated
deflected1635982deflected
deject164512842deject__
dejecta17376362deject_a
dejectedly2452392dejectedly
dejects17389222deject_s
deleted93314912dele_ted
demented12311272demented
depicted1437742depicted
deserted101012202deserted
detecter11298732detecter
detested10279622detested
devested13239132devested
directed1238232directed
disjected2086352disjected
elected102812612_elected
erected103213992_erected
injected18226752injected
objected2043492objected
reejected1955092reejected
refected142311662refected
rejectee17289622rejectee
rejecter17258942rejecter
resected112514742resected
selected1159782selected
advected1534533advected
affected1744793affected
bedecked1874573bedecked
bisected1336203bisected
cemented1338373cemented
coerected1447643coerected
deaerated11311123deaerated
dealated103213603dealated
debated113916083de_bated
debeaked1634613debeaked
debited113311623de_bited
debuted11379333de_buted
decanted122310493decanted
deceased1247723deceased
deceived1535893deceived
decenter112412163decenter
decentred13236233decentred
decerned1237263decerned
decked145217623d__ecked
dedicated14310253dedicated
deduced1266683deduc_ed
deeded94615543de_e_ded
deejayed2042443deejayed
deemed104713063de_e_med
defaced142910973defac_ed
defatted1335673defatted
defeater122611663defeater
defecate1438793defecate_
defecates1538593defecates
defect124816173defect__
defector14277953defector
defects134511523defect_s
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferred13106363deferred
deflated133412303deflated
degermed1335453degermed
degusted1135733degusted
dehorted1357303dehorted
deiced104214483de_ic_ed
dejecting20217793dejecting
dejection19178663dejection
dejeuner1682933dejeuner
delated93722873de_lated
deleaded1148333deleaded
deleaved1346573deleaved
delectated1446723delectated
delegated1238373delegated
delete73620703dele_te_
deletes83117933dele_tes
delisted10310563delisted
demasted1238763demasted
demeaned1237283demeaned
demerged13157603demerged
demerited1339073demerited
demitted12288773demitted
demoted114313543de_moted
denoted93512763de_noted
dentated10411703dentated
dented84120513d__ented
departed1238823departed
depended1337983depended
depermed1436453depermed
depicter1356853depicter
depleted12258723depleted
deported1249703deported
deprecated1646673deprecated
deputed114610173de_puted
derated93623503de_rated
deratted1048403deratted
desalted1038313desalted
desecrated1447953desecrated
deselected1444083deselected
deserter91211603deserter
deserved13108133deserved
desexed1636183dese_xed
desisted1039783desisted
despited1248323despited
detached1537733detached
detect94217403detect__
detecters12217753detecters
detector11278323detector
detects104011093detect_s
detente83313603detente_
detentes92712873detentes
deterged11127923deterged
deterred10137803deterred
detester9239683detester
deticked1635693deticked
detracted1357793detracted
deuced104112123de_uc_ed
deveined1336673deveined
develed123611933deve_led
deviated13311043deviated
devoted124111093de_voted
dieted83115493d_ie_ted
digested11208163digested
directer1137583directer
dissected13108663dissected
diverted13199583diverted
divested13268213divested
ducted104012123d__ucted
dueted84113593d_ue_ted
duetted937023d_uetted
effected1744993effected
egested938123_egested
eject145016043_eject__
ejecta15337393_eject_a
ejector16378603_ejector
ejects15409953_eject_s
electee92513243_electee
enacted10310643_enacted
erecter93113393_erecter
eructed10228653_eructed
everted112711853_everted
evicted1337243_evicted
exacted1737303_exacted
executed1835503_executed
exerted152210053_exerted
expected2036743expected
exsected1835673exsected
infected14229403infected
invected14258883invected
jested144416503__jested
jetted143915083__jetted
leeched13369503le_eched
neglected1354693neglected
obtected1344553obtected
perfected1736643perfected
prelected1439133prelected
projected21165823projected
reacted103015713re_acted
redacted12410243redacted
redefected1743853redefected
reelected1238313reelected
reerected1238613reerected
reested82916233re_ested
reflected1547983reflected
reheated122415003reheated
reinjected2044443reinjected
reject154116283reject__
rejectees18235423rejectees
rejecters18257543rejecters
rejector17237723rejector
rejects163910693reject_s
relented92614943relented
relucted1138653relucted
remelted11310153remelted
renested92212953renested
reobjected2242253reobjected
repeated113117443repeated
repented112614983repented
rerented92516163rerented
reseated93220263reseated
resented92716963resented
respected1438493respected
retested92212533retested
reverted122714713reverted
revested122612243revested
revetted122210943revetted
rewetted12228353rewetted
selectee10910493selectee
subjected2144773subjected
trajected1944043trajected
undetected1444873undetected
unelected1237823unelected
weeted103913793we_e_ted

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.453394461.4
2DLD Change Limit1461622017.34319904.9
3Display Results2012010.0932161.3
 (SQL Overall)1786912017.88922650.7
 
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.