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

275 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
deplane1031141(None) 
deplaned1238651deplaned
deplanes11311211deplanes
biplane1139032biplane
dealate83617842dealate
decane93818872de_cane
declare10411222declare
decline103716612decline
deflate113613942deflate
deglaze1835582deglaze
delaine8314792de_laine
delate73827752de_late
depilate11311702depilate
deplete103010412deplete
deplore1039482deplore
deplume1255062deplume
depone93616552dep_one
deprave1337072deprave
emplane11410012emplane
enplane939722enplane
heptane1238362heptane
plane74929142__plane
replace113214282replace
replan83215822replan_
replans92814942replans
replant93318532replant
replate93420052replate
seaplane1049162seaplane
aeroplane1146593aeroplane
airplane1067793airplane
alane56135613__alane
avellane1146263avellane
bedplate1346223bedplate
beeline93314723beeline
berline93716853berline
biplanes1238573biplanes
cellae84915933cella_e
cetane8315283ce_tane
daphne12237013dap_hne
dapsone1038463dapsone
deadline10139053deadline
dealated103213603dealated
dealates92716683dealates
dealing94323233dealing
dean56039483de__an_
deaned84620453de__aned
deans66131393de__ans
deave95022333de__ave
debase94014473de_base
debate94419193de_bate
debone93714783de_bone
decade104216163de_cade
decanes103118913de_canes
decant93524223de_cant
decare93919153de_care
decease1049523decease
deciare10710663deciare
declaim1247363declaim
declared1248743declared
declarer1148063declarer
declares11611313declares
declass1038733declass
declasse1165943declasse
declaw1266703decla_w
declawed1545923declawed
declaws1336253declaws
declined123910883declined
decliner113710843decliner
declines113315803declines
dedans85915073de_dans
deewan10267553deewan_
deewans11306903deewans
deface123113863de_face
defame123212433de_fame
defang1137753de_fang
defiance1477633defiance
defiant11311923defiant
defilade13124433defilade
define104718143de_fine
deflated133412303deflated
deflater123211603deflater
deflates123013943deflates
degage92711383de_gage
degame102713183de_game
deglazed2034953deglazed
deglazes1935463deglazes
degrade10229903degrade
dekare112811563de_kare
delaines9312963de_laines
delated93722873de_lated
delates83526283de_lates
delay94820633de_la_y
delayed123310763de_layed
delayer113010533de_layer
delays104014053de_lays
dele56843083de_l__e
deleave1147723deleave
delete73620703de_lete
delime9314043de_lime
delude81910673de_lude
deluge8189403de_luge
deluxe14197303de_luxe
delve96018263de_l_ve
demand104314253de_mand
demean9510563demean_
demeaned1237283demeaned
demeans1039713demeans
demesne1035573demesne
demilune1144423demilune
dene56643413de___ne
dentate8315153dentate
dentine83320243dentine
deodand1035713deodand
depaint10314593depaint
depart94720563dep_art
depend103510923dep_end
depilated1339653depilated
depilates12310923depilates
deplaning1338053deplaning
depleted12258713depleted
depleter11298853depleter
depletes112810633depletes
deplored1237223deplored
deplorer1136343deplorer
deplores1139533deplores
deploy1237583depl_oy
deployed1535903deployed
deployer1445633deployer
deploys1336523deploys
deplumed1434073deplumed
deplumes1334943deplumes
deponed113712873dep_oned
depones103717093dep_ones
depose94215763dep_ose
depraved1535543depraved
depraver1435413depraver
depraves1436873depraves
deprive1338303deprive
depside1138403depside
depurate1139983depurate
depute94512303dep_ute
derange939813de_range
derate74531233de_rate
desand84812633de_sand
descant104315583descant
desman9311693desman_
desmans1039003desmans
desolate9411993desolate
destine83719953destine
devalue1136013devalue
deviance1477083deviance
deviant11311313deviant
deviate11312713deviate
dewan95718043de_wan_
dewans105215143de_wans
dewlap1264843dewla_p
dewlaps1334663dewlaps
dilate73220693d_ilate
dioxane1565423dioxane
diphase1387273diphase
diploe9810153dipl_oe
diplont10311693diplont
displace1348653displace
displant11412223displant
dogbane1135653dogbane
dogvane1243853dogvane
dopant9316133dop_ant
dryland1254303dryland
duple85315863dupl__e
elan46734243_e_lan_
eland65820393_e_land
elans55527753_e_lans
elate55335883_e_late
emplace1338263emplace
emplaned1337153emplaned
emplanes1239503emplanes
enlace82213233_enlace
enplaned1137473enplaned
enplanes1039483enplanes
epilate9314283_epilate
ethane94613243_ethane
explant16310133explant
feline94820143fe_line
fellate10313433fellate
fenland1135693fenland
gelant72821673ge_lant
gelate73421253ge_late
gellant83214053gellant
germane1049663germane
hemline12311073hemline
henbane1237353henbane
heptanes1339003heptanes
hexane16379533he_xane
hipline12311423hipline
implant11311333implant
keelage1236183keelage
lane45153333___lane
melange1038363me_lange
methane123211793methane
noplace1137393noplace
pane64950293__p_ane
pelage9515363pe_lage
peneplane1344663peneplane
pentane9415743pentane
pepla9312863pepla__
pepsine11310603pepsine
peptone11310763peptone
pieplant1268733pieplant
place94824613__place
plage84520403__plage
plan65833943__plan_
planed94420913__planed
planer84122653__planer
planes85028083__planes
planet84228353__planet
plank115221143__plank
plans75731273__plans
plant75437113__plant
plate74635113__plate
preplace1488973preplace
preplan1149953preplan_
preplans1249613preplans
preplant12712913preplant
recane83022873re_cane
reclame11411063reclame
recline94020493recline
redline84218833redline
reflate103516263reflate
reglaze1747223reglaze
relace83122153re_lace
reland75920433re_land
relate64033633re_late
reline65434353re_line
repand95316063rep_and
repanel939963rep_anel
repave114813873rep_ave
repine85627813rep_ine
replaced133211393replaced
replacer12279743replacer
replaces123114123replaces
replanned1235163replanned
replanted1248063replanted
replants102811243replants
replated112817513replated
replates102919273replates
replay113412923repla_y
replayed14248623replayed
replays12399763replays
replete92912983replete
replunge1143963replunge
reptant92817073reptant
reslate73520593reslate
sealant73118303sealant
seaplanes1148713seaplanes
sepaline10311343sepaline
septage1078403septage
septate9511873septate
setline7313923setline
silane62718053_silane
skiplane1444833skiplane
splake1259783_splake
spline86020533_spline
telae54323293te_la_e
template1238433template
terrane72814233terrane
toeplate1047613toeplate
tolane64316583_tolane
topline92313183topline
towplane1345313towplane
triplane1039113triplane
upland938863_upland
velate93720143ve_late
volplane1344313volplane
warplane1345983warplane
wetland1135353wetland

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272756.61020276.4
3Display Results2752750.1062594.3
 (SQL Overall)1786912756.87226002.8
 
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.