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

268 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
deplanes1131121(None) 
deplane10311411deplane_
deplaned1238661deplaned
biplanes1238572biplanes
dealates92716682dealates
decanes103118912de_canes
declares11611322declares
declines113315802declines
deflates123013942deflates
deglazes1935462deglazes
delaines9312962de_laines
delates83526282de_lates
depilates12310922depilates
depletes112810642depletes
deplores1139532deplores
deplumes1334942deplumes
depones103717092dep_ones
depraves1436872depraves
emplanes1239502emplanes
enplanes1039482enplanes
heptanes1339002heptanes
planes85028082__planes
replaces123114122replaces
replans92814942replan_s
replants102811242replants
replates102919282replates
seaplanes1148722seaplanes
aeroplanes1246883aeroplanes
airplanes1187233airplanes
bedplates1445493bedplates
beelines103312803beelines
berlines102315463berlines
biplane1139033biplane_
cetanes9315133ce_tanes
daphnes13327683dap_hnes
dapsones1138383dapsones
deadlines11138503deadlines
dealate83617843dealate_
dealated103213603dealated
dealings103510703dealings
deaned84620453de__aned
deans66131393de__an_s
deaves105319533de__aves
debases103814133de_bases
debates103718533de_bates
debones103315113de_bones
decades113615513de_cades
decane93818873de_cane_
decants103514443de_cants
decares102818533de_cares
deceases11410153deceases
deciares11510633deciares
declaims1345823declaims
declare10411233declare_
declared1248753declared
declarer1148073declarer
declarers1236423declarers
declass1038733decla_ss
declasse1165943declasse
declasses1246443declasses
declawed1545933declawed
declaws1336253decla_ws
decline103716613decline_
declined123910883declined
decliner113710843decliner
decliners12358613decliners
dedans85915073de_dan_s
deewans11306903deewan_s
defaces133213403de_faces
defames132812253de_fames
defangs1235363de_fangs
defiances1557033defiances
defilades14134073defilades
defines114118683de_fines
deflate113613943deflate_
deflated133412303deflated
deflater123211603deflater
deflaters13298703deflaters
degames113312623de_games
degases93413103de_gases
deglaze1835583deglaze_
deglazed2034953deglazed
degrades11269923degrades
dekares122710873de_kares
delaine8314793de_laine_
delate73827753de_late_
delated93722873de_lated
delayed123310763de_layed
delayer113010533de_layer
delayers12268663de_layers
delays104014053de_la_ys
deleaves1248063deleaves
deles65139253de_l__es
deletes83117933de_letes
delimes10314193de_limes
dellies83622213de_llies
deludes91810643de_ludes
deluges9169263de_luges
delves104917083de_l_ves
demands114311413de_mands
demeaned1237283demeaned
demeans1039723demean_s
demesnes1137083demesnes
demilunes1244473demilunes
denes65639723de___nes
dentines93418403dentines
deodands1144603deodands
depaints1136643depaints
departs104310683dep_arts
depends11348993dep_ends
depilate11311703depilate_
depilated1339653depilated
deplaning1338053deplaning
deplete103010423deplete_
depleted12258723depleted
depleter11298863depleter
depleters12327543depleters
deplore1039483deplore_
deplored1237233deplored
deplorer1136343deplorer
deplorers1245463deplorers
deployed1535913deployed
deployer1445633deployer
deployers1545063deployers
deploys1336523depl_oys
deplume1255063deplume_
deplumed1434083deplumed
depone93616553dep_one_
deponed113712873dep_oned
deposes103117213dep_oses
deprave1337073deprave_
depraved1535543depraved
depraver1435413depraver
depravers1534683depravers
deprives1438393deprives
depsides1238503depsides
depurates1239823depurates
deputes104911783dep_utes
deputies1157533deputies
deranges1039973de_ranges
derates84028893de_rates
desands94810163de_sands
descants112910143descants
desmans1039003desman_s
desolates10311793desolates
destines93619663destines
devalues1235853devalues
deviances1566493deviances
deviants1236743deviants
deviates12312753deviates
dewans105215143de_wan_s
dewaxes18297843de_waxes
dewlaps1334663dewla_ps
dilates83220663d_ilates
dioxanes1645373dioxanes
diploes101111493dipl_oes
diplonts1146473diplonts
diploses111110323diploses
dipsades1246493dipsades
displaces1448593displaces
displants1248073displants
doblones1136763doblones
dogbanes1245433dogbanes
dogvanes1344303dogvanes
dopants1038433dop_ants
duplexes1844053duplexes
elands74914773_e_lands
elans55527753_e_lan_s
elates65032363_e_lates
emplaces1438413emplaces
emplane11410013emplane_
emplaned1337163emplaned
enlaces92313393_enlaces
enplane939723enplane_
enplaned1137483enplaned
epilates10313503_epilates
ethanes103713513_ethanes
explants1737023explants
felines104718073fe_lines
fellates11312753fellates
fenlands1245183fenlands
flanes94522423__flanes
gelants82611443ge_lants
gelates83219593ge_lates
gellants9308283gellants
hemlines13310623hemlines
henbanes1336583henbanes
heptane1238363heptane_
hexanes17319463he_xanes
hiplines13310593hiplines
implants1237883implants
keelages1335753keelages
lanes54946793___lanes
melanges1138613me_langes
methanes133812163methanes
panes76148693__p_anes
pelages10714613pe_lages
peneplanes1444323peneplanes
pentanes10316083pentanes
peploses1269473peploses
pepluses1287023pepluses
pepsines1239883pepsines
peptones12311033peptones
pieplants1355433pieplants
places104323703__places
plages94520153__plages
plane74929143__plane_
planed94420913__planed
planer84122663__planer
planers94517953__planers
planet84228353__planet
planets93914083__planets
planks124116753__planks
plans75731273__plan_s
plants84921803__plants
plates85432243__plates
preplaces1578753preplaces
preplans1249613preplan_s
recanes93222263re_canes
reclames12310893reclames
reclines103718543reclines
redlines93916083redlines
reflates113115673reflates
reglazes1846793reglazes
relaces93420883re_laces
relands85214883re_lands
relates73731443re_lates
relaxes143215323re_laxes
relines75331323re_lines
repanel939963rep_anel
repanels1036783rep_anels
repaves123513653rep_aves
repines94927383rep_ines
replace113214283replace_
replaced133211403replaced
replacer12279743replacer
replacers13266833replacers
replan83215823replan__
replanned1235163replanned
replant93318533replan_t
replanted1248063replanted
replate93420053replate_
replated112817523replated
replayed14248633replayed
replays12399763repla_ys
repletes102812473repletes
replies94521043repl_ies
replunges1243663replunges
reslates83619513reslates
sealants82610743sealants
seaplane1049163seaplane_
septages1168263septages
setlines8312743setlines
silanes72517163_silanes
skiplanes1544633skiplanes
splakes1349673_splakes
splines94718893_splines
templates1348273templates
terranes82514433terranes
toeplates1147183toeplates
tolanes74216313_tolanes
toplines102412563toplines
towplanes1444683towplanes
triplanes1148803triplanes
uplands1036943_uplands
volplanes1444673volplanes
warplanes1445893warplanes
wetlands1244763wetlands

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.453394461.4
2DLD Change Limit1461622688.01318240.6
3Display Results2682680.1102436.4
 (SQL Overall)1786912688.57620836.2
 
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.