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

157 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
plant7543711(None) 
alant55742291alant
pant66061261p_ant
plaint85323201plaint
plait75631571plait
plan65833941plan_
plane74929141plane
planet84228351planet
plank115221141plank
plans75731271plans
plants84921801plants
plat66048871pla_t
pliant83918821pliant
slant55238701slant
alan46844082alan_
aland65526412aland
alane56135612alane
alang66023512alang
alans55636172alans
alants67722022alants
ant37270792__ant
aslant6317752aslant
avant86224662avant
bland85320452bland
blank115418552blank
blast76532572blast
blat66550952bla_t
blent76230952blent
blunt75525022blunt
brant74742172brant
cant66362032_cant
chant105932692chant
clan65633922clan_
clang86019312clang
clank114719522clank
clans75031012clans
clapt98027172clapt
clast76030582clast
elan46734242elan_
eland65820392eland
elans55527752elans
elint55436472elint
eluant6315092eluant
explant16310132explant
flan76134182flan_
flank124618092flank
flans85327972flans
flat77147822fla_t
flaunt9712912flaunt
flint87333502flint
gelant72821672gelant
giant65430592giant
gland75217712gland
glans65125832glans
glint66830182glint
grant64840022grant
hant75461592_hant
implant11311332implant
land56337312_land
lane45153332_lane
lang56637382_lang
lank84734452_lank
last46260322_last
lat37593402_la_t
leant56737782leant
lent46360532_lent
lint416266232_lint
llano5910602llano
lunt46148842_lunt
meant76537212meant
pact86648722p_act
paint75443692paint
palet74650802palet
pan58466452p_an_
pane64950292p_ane
pang75336292p_ang
pans65855732p_ans
panto76129412p_anto
pants76536922p_ants
panty105929302p_anty
part65967462p_art
past65959012p_ast
pat58089462p_a_t
pean66147172pean_
peans75437642peans
peanut8318182peanut
peart76440752peart
peat65967932pea_t
pedant9319492pedant
pent66559072p_ent
phat95837862pha_t
pian66136092pian_
piano76118712piano
pians75126962pians
pint66963172p_int
place94824612place
placet103923672placet
plack135017842plack
plage84520402plage
plaid85118302plaid
plain74823302plain
plains85019592plains
plaints94012052plaints
plaits83816472plaits
planar84212712planar
planate9314572planate
planch133711442planch
planed94420912planed
planer84122652planer
planes85028082planes
planets93914082planets
planks124116752planks
plantar9369992plantar
planted103516122planted
planter94017802planter
plash104616562plash
plasm94114632plasm
plate74635112plate
plats75531372plats
platy105021662platy
play95928982pla_y
playa105812942playa
plays106320772plays
plaza164311062plaza
pleat74734472pleat
plena75816392plena
plenty11311412plenty
plink115219122plink
plinth11310452plinth
plonk114613982plonk
plot66141232pl_ot
plunk114514402plunk
point75338732point
prang84820322prang
prank115019452prank
prat65952042pra_t
print74837462print
pulsant9310562pulsant
punt65747202p_unt
quant143624812quant
rant45864682_rant
replant93318532replant
riant55833152riant
scant79735072scant
slang66324022slang
slank95822772slank
slants64819082slants
slanty95114842slanty
slat46959022sla_t
splat76129342spla_t
splent84720192splent
splint85223282splint
ulan46527392ulan_
ulans54921302ulans
upland938862upland
volant9316322volant
want76156172_want

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.313570897.8
2DLD Change Limit538001571.57634137.1
3Display Results1571570.0463413.0
 (SQL Overall)1786911571.93592346.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.