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

243 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
deplaned123866(None) 
deplane10311411deplane_
deplanes11311211deplanes
dealated103213602dealated
deaned84620452de__aned
declared1248742declared
declawed1545922declawed
declined123910882declined
deflated133412302deflated
deglazed2034952deglazed
delated93722872de_lated
delayed123310762de_layed
demeaned1237282demeaned
depilated1339652depilated
depleted12258722depleted
deplored1237232deplored
deployed1535912deployed
deplumed1434082deplumed
deponed113712872dep_oned
depraved1535542depraved
emplaned1337162emplaned
enplaned1137482enplaned
planed94420912__planed
replaced133211402replaced
replanned1235162replanned
replanted1248062replanted
replated112817522replated
replayed14248632replayed
beaned95621473be__aned
beelined11277713beelined
belaced124112153be_laced
belated103520013be_lated
belayed133610083be_layed
bemeaned1335783bemeaned
bemoaned1335553bemoaned
beslaved1435023beslaved
biplane1139033biplane_
biplanes1238573biplanes
cellared11398793cellared
deaconed1237493deaconed
deadened1137233deadened
deadlined12125323deadlined
deafened1335853deafened
dealate83617843dealate_
dealates92716683dealates
deaved114916553de__aved
debased113310583de_based
debated113916083de_bated
debeaked1634613debeaked
deboned113411633de_boned
decane93818873de_cane_
decanes103118913de_canes
decanted122310493de_canted
decayed14309333de_cayed
deceased1247713deceased
decerned1237263decerned
declaimed1544383declaimed
declare10411223declare_
declarer1148063declarer
declares11611313declares
declassed1344993declassed
decline103716613decline_
decliner113710843decliner
declines113315803declines
deejayed2042443deejayed
deepened1235663deepened
defaced142910973de_faced
defamed14309833de_famed
defanged1435433de_fanged
defeated132812163defeated
defiladed15143473defiladed
defined123813823de_fined
deflate113613943deflate_
deflater123211603deflater
deflates123013943deflates
defleaed1344953defleaed
deflexed2043883deflexed
defoamed15356243defoamed
defrayed1635403defrayed
deglaze1835583deglaze_
deglazes1935463deglazes
degraded12288323degraded
dehorned1345683dehorned
deigned1037503de_igned
delaine8314793de_laine_
delaines9312963de_laines
delate73827753de_late_
delates83526283de_lates
delayer113010533de_layer
deleaded1148333deleaded
deleaved1346573deleaved
deled75326543de_l__ed
deleted93314913de_leted
delimed11310723de_limed
deluded10158763de_luded
deluged10167413de_luged
delved114112753de_l_ved
demand104314253de_man_d
demanded13348513de_manded
denned84215633de__nned
dentated10411703dentated
deodand1035713deodan_d
depainted1375843depainted
departed1238823departed
depend103510923dep_en_d
depended1337983depended
depermed1436453depermed
depicted1437743depicted
depilate11311703depilate_
depilates12310923depilates
deplaning1338053deplaning
deplete103010423deplete_
depleter11298863depleter
depletes112810643depletes
deplore1039483deplore_
deplorer1136343deplorer
deplores1139533deplores
deployer1445633deployer
deplume1255063deplume_
deplumes1334943deplumes
depone93616553dep_one_
depones103717093dep_ones
deported1249703deported
deposed113412023dep_osed
deprave1337073deprave_
depraver1435413depraver
depraves1436873depraves
deprived1546463deprived
depurated1338183depurated
deputed114610173dep_uted
deranged1137693de_ranged
derated93623503de_rated
desalted1038313desalted
desand84812633de_san_d
desanded11227453de_sanded
descanted1336673descanted
designed1136943designed
desolated1139653desolated
destained1158253destained
destined103312453destined
detained103111643detained
detrained1158913detrained
devalued1335013devalued
deveined1336673deveined
deviated13311043deviated
dewaxed19316053de_waxed
dewclawed1941533dewclawed
dewlapped1841953dewlapped
dilated93115823d_ilated
displaced1546793displaced
displanted14126633displanted
displayed1645883displayed
dryland1254303drylan_d
duplexed1943143duplexed
eland65820393_e_lan_d
elated74725823_e_lated
emplaced1536053emplaced
emplane11410013emplane_
emplanes1239503emplanes
enlaced102410523_enlaced
enplane939723enplane_
enplanes1039483enplanes
epilated11310753_epilated
explained1944543explained
explanted1944973explanted
fellated1239563fellated
fenland1135693fenlan_d
gelated93615633ge_lated
heptane1238363heptane_
heptanes1339003heptanes
implanted1475493implanted
jeaned143813463je__aned
leaned73422543le__aned
melamed1249633me_lamed
orphaned1445153orphaned
paned85437183__p_aned
peplumed1543043peplumed
placed114318003__placed
plained103812233__plained
plane74929143__plane_
planer84122653__planer
planes85028083__planes
planet84228353__planet
planked143512283__planked
planned103810153__planned
planted103516123__planted
plated95225773__plated
played124815033__played
preplaced1676483preplaced
preplanned1543503preplanned
recaned102817203re_caned
recleaned1236583recleaned
reclined113613603reclined
redlined103811233redlined
reflated123514293reflated
reglazed1935743reglazed
relaced103517213re_laced
reland75920433re_lan_d
relanded102410463re_landed
related83327573re_lated
relaxed153312533re_laxed
relayed113212753re_layed
relined85321933re_lined
reloaned939723reloaned
repand95316063rep_an_d
repanel939963rep_anel
repaved133311133rep_aved
repealed113211873repealed
repeated113117443repeated
repined104918773rep_ined
repinned1157473repinned
replace113214283replace_
replacer12279743replacer
replaces123114123replaces
replan83215823replan__
replans92814943replan_s
replant93318533replan_t
replants102811243replants
replate93420053replate_
replates102919273replates
repleaded1336293repleaded
repled93319783repl__ed
replied103914453repl_ied
replowed14127573replowed
replunged1343383replunged
repugned1235363repugned
reslated93517523reslated
seaplane1049163seaplane_
seaplanes1148713seaplanes
sepaled10510593sep_aled
sepalled1156903sepalled
speaned103411523_speaned
splayed13357813_splayed
splined105013113_splined
unplaced1338613unplaced
unplanned1244413unplanned
unplanted1236853unplanted
unplayed1437263unplayed
upland938863_uplan_d
volplaned1542733volplaned
weaned103816153we__aned
wetland1135353wetlan_d
yeaned103813903ye__aned

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.423422437.4
2DLD Change Limit1461622436.65621959.4
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.17224915.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.