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 “plane” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

207 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
plane7492914(None) 
alane56135611alane
lane45153331_lane
pane64950291p_ane
place94824611place
plage84520401plage
plan65833941plan_
planed94420911planed
planer84122651planer
planes85028081planes
planet84228351planet
plank115221141plank
plans75731271plans
plant75437111plant
plate74635111plate
alae45643752ala_e
alan46844082alan_
aland65526412aland
alang66023512alang
alans55636172alans
alant55742292alant
alate55340322alate
aline57243152aline
alkane104313322alkane
alone55732962alone
ane37866952__ane
bane65250432_bane
biplane1139032biplane
blade85923332blade
blae66134642bla_e
blame95625492blame
bland85320452bland
blank115418552blank
blare75826232blare
blase75524232blase
blate75933782blate
blaze165520832blaze
cane66653122_cane
clade85821012clade
clan65633922clan_
clang86019312clang
clank114719522clank
clans75031012clans
clave105420152clave
cline76428532cline
clone75728162clone
crane75331602crane
deplane10311412deplane
elan46734242elan_
eland65820392eland
elans55527752elans
elate55335882elate
emplane11410012emplane
enplane939722enplane
fane75343572_fane
flake125119972flake
flame105124442flame
flan76134182flan_
flanes94522422flanes
flange103411972flange
flank124618092flank
flans85327972flans
flare84823632flare
gane55145302_gane
glace87420152glace
glade75121962glade
glance94312312glance
gland75217712gland
glans65125832glans
glare65222952glare
glaze155418162glaze
inane52820342inane
jane115031482_jane
kane85133972_kane
lace66848472_lace
lade56345982_lade
lake85741602_lake
lame66849292_lame
lance75126722_lance
land56337312_land
lanes54946792_lanes
lang56637382_lang
lank84734452_lank
lase46148512_lase
late47560482_late
lave75642142_lave
laze136235052_laze
liane54720662liane
line46965572_line
llano5910602llano
lone45849132_lone
lune47140492_lune
mane65052032_mane
pace86345772p_ace
page76036102p_age
palace104516912palace
palate84226782palate
pale66055012p_ale
pan58466452p_an_
paned85437182p_aned
panel76023622p_anel
panes76148692p_anes
pang75336292p_ang
panne76623652panne
pans65855732p_ans
pant66061262p_ant
pare66760842p_are
pase65346862p_ase
pate65350462p_ate
pavane114113442pavane
pave96133892p_ave
peace95026082peace
peage84723562peage
pean66147172pean_
peans75437642peans
pease75231112pease
pelage9515362pelage
penne75423852penne
phage115113672phage
phase104617212phase
phone105621932phone
pian66136092pian_
piano76118712piano
pians75126962pians
pine67755712p_ine
placed114318002placed
placer105117742placer
places104323702places
placet103923672placet
plack135017842plack
plages94520152plages
plague93610852plague
plaice10311552plaice
plaid85118302plaid
plain74823302plain
plained103812232plained
plainer93811982plainer
plains85019592plains
plaint85323202plaint
plait75631572plait
planar84212712planar
planate9314572planate
planch133711442planch
planche14299752planche
planers94517942planers
planets93914082planets
planked143512282planked
planks124116752planks
planned103810152planned
planner93511622planner
planted103516122planted
planter94017802planter
plants84921802plants
plaque17317642plaque
plash104616562plash
plasm94114632plasm
plat66048872pla_t
platane93112302platane
plated95225772plated
platen84518202platen
plater84427692plater
plates85432242plates
plats75531372plats
platy105021662platy
play95928982pla_y
playa105812942playa
played124815032played
player115215212player
plays106320772plays
plaza164311062plaza
please84315732please
plebe95014872plebe
plena75816392plena
pliant83918822pliant
plie65127392pl_ie
plink115219122plink
plonk114613982plonk
plume94819462plume
plunge93811052plunge
plunk114514402plunk
pone65747532p_one
prance104318572prance
prang84820322prang
prank115019452prank
prase76128752prase
prate75135982prate
prone75332622prone
prune75119632prune
sane45954342_sane
silane62718052silane
slake93724052slake
slang66324022slang
slank95822772slank
slant55238702slant
slate55438282slate
slave84224032slave
splake1259782splake
spline86020532spline
stane55933002stane
thane86122532thane
tolane64316582tolane
ulan46527392ulan_
ulans54921302ulans
ulnae55214572ulnae
upland938862upland
vane75534692_vane
wane76344722_wane

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002071.59333772.8
3Display Results2072070.0464500.0
 (SQL Overall)1786912071.732103170.3
 
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.