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

341 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
deflated13341230(None) 
dealated103213601dealated
defeated132812161defeated
deflate113613941deflate_
deflater123211601deflater
deflates123013941deflates
delated93722871de_lated
reflated123514291reflated
belated103520012be_lated
dealate83617842dealate_
dealates92716682dealates
debated113916082de_bated
declared1248742declared
declawed1545922declawed
defaced142910972def_aced
defalcated1744182defalcated
defamed14309832def_amed
defatted1335672defatted
defeater122611662defeater
defecated1637492defecated
defected15289972defected
defiladed15143472defiladed
deflaters13298702deflaters
deflator12328342deflator
defleaed1344952defleaed
deflected1635982deflected
deflexed2043882deflexed
defoamed15356242defoamed
defoliated1545832defoliated
defrayed1635402defrayed
deglazed2034952deglazed
delate73827752de_late_
delates83526282de_lates
delayed123310762de_layed
deleted93314912de_leted
dentated10411702dentated
depilated1339652depilated
deplaned1238662deplaned
depleted12258722depleted
derated93623502de_rated
desalted1038312desalted
desolated1139652desolated
deviated13311042deviated
dilated93115822d_ilated
elated74725822_e_lated
fellated1239562fellated
gelated93615632ge_lated
inflated12410862inflated
reflate103516262reflate_
reflates113115662reflates
refloated1347012refloated
related83327572re_lated
replated112817522replated
reslated93517522reslated
ablated102513443_ablated
acylated1437873acylated
adulated1039753adulated
aerated85322373ae_rated
alated75625143__alated
areolated1089713areolated
befitted14305723befitted
beflagged1742423beflagged
befleaed1454663befleaed
belaced124112153be_laced
belayed133610083be_layed
belted94020633be_l_ted
berated104422133be_rated
beslaved1435023beslaved
cellared11398793cellared
cerated103922473ce_rated
chelated142610483chelated
collated113615063collated
conflated1539333conflated
dated75530993d___ated
deaerated11311113deaerated
deaned84620453de__aned
deaved114916553de__aved
debased113310583de_based
debate94419193de_bate_
debater104114693de_bater
debates103718533de_bates
debeaked1634613debeaked
debited113311623de_bited
debuted11379333de_buted
decanted122310493decanted
decayed14309333de_cayed
deceased1247713deceased
decimated1548953decimated
declaimed1544383declaimed
declare10411223declare_
declarer1148063declarer
declares11611313declares
declassed1344993declassed
declined123910883declined
decocted1437683decocted
decollated14136283decollated
decorated13312203decorated
dedicated14310253dedicated
deducted1356243deducted
deejayed2042443deejayed
deface123113863def_ace_
defacer132810363def_acer
defaces133213403def_aces
defalcate1544923defalcate_
defalcates1644543defalcates
defame123212433def_ame_
defamer132710323def_amer
defames132812253def_ames
defanged1435433defanged
defat95426693def_at__
defats105114553def_at_s
defaulted1443313defaulted
defeat103817163defeat__
defeaters13289103defeaters
defeats113511233defeat_s
defecate1438793defecate_
defecates1538593defecates
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferred13106363deferred
defied115016383def__ied
defilade13124433defilade_
defilades14134073defilades
defiled124013103def_iled
defined123813823def_ined
deflagrated17132993deflagrated
deflating142610713deflating
deflation13310653deflation
deflators13348153deflators
deflea1037443defl__ea
deflower15126073deflower
defoamer14276213defoamer
defogged1533783defogged
defoliate1346993defoliate_
defoliates1446333defoliates
deforced15247373deforced
deformed15248263deformed
defragged1643043defragged
defraud1243913defra_ud
defrauded1542823defrauded
defrayer1534933defrayer
defrosted1444253defrosted
defter104215923def__ter
defueled1374513defueled
defunded1435163defunded
defused125211093def_used
defuzed21447043def_uzed
deglaze1835583deglaze_
deglazes1935463deglazes
degraded12288323degraded
degusted1135733degusted
dehorted1357303dehorted
dejected19307593dejected
delator83015023de_lator
delayer113010533de_layer
deleaded1148333deleaded
deleaved1346573deleaved
deled75326543de_l__ed
delegated1238373delegated
delete73620703de_lete_
deletes83117933de_letes
delimed11310723de_limed
delisted10310563delisted
deluded10158763de_luded
deluged10167413de_luged
delved114112753de_l_ved
demasted1238763demasted
demeaned1237283demeaned
demented12311273demented
demitted12288773demitted
demoted114313543de_moted
denoted93512763de_noted
dentate8315153dentate_
dented84120513de__nted
denudated1244933denudated
departed1238823departed
depicted1437743depicted
depilate11311703depilate_
depilates12310923depilates
deplane10311413deplane_
deplanes11311213deplanes
deplete103010423deplete_
depleter11298863depleter
depletes112810643depletes
deplored1237233deplored
deployed1535913deployed
deplumed1434083deplumed
deported1249703deported
depraved1535543depraved
depurated1338183depurated
deputed114610173de_puted
derate74531233de_rate_
derates84028893de_rates
deratted1048403deratted
derogated1238673derogated
desalter938363desalter
descanted1336673descanted
deserted101012203deserted
desisted1039783desisted
desolate9411993desolate_
desolater1038383desolater
desolates10311793desolates
despited1248323despited
detected12289733detected
detested10279623detested
detonated1138213detonated
detracted1357793detracted
devaluated15265493devaluated
devalued1335013devalued
devested13239133devested
deviate11312713deviate_
deviates12312733deviates
devoted124111093de_voted
dewater112912423de_water
dewaxed19316053de_waxed
dewclawed1941533dewclawed
dewlapped1841953dewlapped
dictated1239203dictated
dilate73220693d_ilate_
dilater83515653d_ilater
dilates83220663d_ilates
diluted9248933d_iluted
disrated10915573disrated
doated84118183d__oated
donated93513863d_onated
educated1237943educated
effaced16225573_effaced
elate55335883_e_late_
elater64724203_e_later
elates65032363_e_lates
eluted74915263_e_luted
emulated11310793emulated
enflamed1455723enflamed
enlaced102410523_enlaced
epilated11310753epilated
equated171910403_equated
estated83715573_estated
exalted1537393_exalted
fated95632133__f_ated
fellate10313433fellate_
fellates11312753fellates
felted103714653fe_l_ted
flaked144715653__flaked
flamed124618973__flamed
flared105317603__flared
flatbed13397983__flatbed
flatted114012943__flatted
flawed134712723__flawed
flayed134414053__flayed
flited104616583__flited
floated113312703__floated
fluted104917163__fluted
flyted13378773__flyted
gelate73421253ge_late_
gelates83219583ge_lates
gemmated14336293gemmated
gestated102910573gestated
heated104525593he__ated
hefted134911423hef__ted
ideated9310973ide__ated
inflamed1446033inflamed
inflate10312313inflate_
inflater1149893inflater
inflates11512193inflates
isolated9410523isolated
lated65240673___lated
leafleted1342893leafleted
legated92513983le_gated
meated94222403me__ated
mediated123011873mediated
melamed1249633me_lamed
melted94219063me_l_ted
negated93413233ne_gated
ocellated1245453ocellated
ovulated1237083ovulated
oxalated1695323oxalated
peculated142310853peculated
pelleted1138203pelleted
pelted94617763pe_l_ted
pennated11299543pennated
plated95225773__plated
rebated103619703re_bated
recoated113416783recoated
recrated112918603recrated
redated93120923re_dated
redefeated1544883redefeated
refaced133713573ref_aced
refected142311663refected
refitted12309413refitted
reflagged1543093reflagged
reflected1547983reflected
reflexed1975253reflexed
reflowed15126903reflowed
refluxed1954353refluxed
refracted1557393refracted
reframed1437853reframed
refuted114313803ref_uted
regelated1139723regelated
reglazed1935743reglazed
regrated102816333regrated
regulated11310463regulated
reheated122415003reheated
reinflated14146473reinflated
relaced103517213re_laced
relate64033633re_late_
relater73723143re_later
relates73731433re_lates
relaxed153312533re_laxed
relayed113212753re_layed
remated103522473re_mated
repeated113117443repeated
replaced133211403replaced
replanted1248063replanted
replate93420053replate_
replates102919273replates
replayed14248633replayed
reseated93220263reseated
reslate73520593reslate_
reslates83619503reslates
restated93120183restated
seated75131063se__ated
sedated93714353se_dated
sensated938193sensated
seriated92717023seriated
serrated92513433serrated
slated75028313__slated
solated83618023_solated
stellated1046803stellated
sublated11311503sublated
sufflated1644623sufflated
sulfated1238833sulfated
teated74924023te__ated
tegulated1146633tegulated
ululated947663ululated
undefeated1546203undefeated
unflawed1536123unflawed
unfluted1237173unfluted
velate93720143ve_late_
violated1237883violated
welted103715823we_l_ted

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.423422437.4
2DLD Change Limit1461623417.82618676.5
3Display Results3413410.1562185.9
 (SQL Overall)1786913418.40521260.1
 
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.