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

132 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
planula93577(None) 
planulae1044791planulae
planular1044751planular
canula8312962_canula
lunula636172_lunula
papula103011112p_apula
pinnula934912pinnula
planulate1146902planulate
ranula6311812_ranula
alanyl955483alanyl_
alanyls1084353alanyls
alula5317093__alula
bacula103112673_bacula
blandly1336043blandly
blankly1634263blankly
blastula1043823blastula
cannula937433cannula
canola8313623_canola
canulae9311183_canulae
canular9310323_canular
canulas9312853_canulas
coagula1045413coagula
facula112912233_facula
flauta937823fla_uta
frenula1045623frenula
glandular1142783glandular
glandule1043853glandule
granola837913granola
granular946893granular
granule839473granule
lacuna8118123_lacuna
laguna7127223_laguna
lanely93914483_lanely
lankly13439623_lankly
lanugo735573_lanugo
laura54116203_la_ura
lazuli1535363_lazuli
ligula7359673_ligula
lingula8428803_lingula
lunulae735613_lunulae
lunular736013_lunular
lunule638433_lunule
macula103013673_macula
manila84518303_manila
manual8313463_manual
pabular11259473p_abular
paella8410913p_aella
panada94113053p_anada
panama104213353p_anama
panda85022613p_an_da
pandura1037143p_andura
panel76023623p_anel_
panels84716523p_anels
panful1179743p_anful_
panfuls1237173p_anfuls
panga85323533p_an_ga
papulae11249353p_apulae
papular11299763p_apular
papule102212133p_apule
parura8310583p_arura
payola11208113p_ayola
peanut8318183peanu_t
peanuts936993peanuts
penult8314653p_enult
piacular1246573piacular
pinnulae1044183pinnulae
pinnular1044433pinnular
pinnule936003pinnule
plagal948573plagal_
plague93610853plagu_e
plagued11307473plagued
plaguer10328273plaguer
plagues103311063plagues
plaguey13335943plaguey
plaguily1443513plaguily
plaguy12386413plagu_y
plainly1236473plainly
plan65833943plan___
planar84212713plan_ar
planaria1047353planaria
planate9314573planate
planch133711443plan_ch
planche14299753planche
plane74929143plan__e
planed94420913plan_ed
planeload1243723planeload
planer84122653plan_er
planers94517943planers
planes85028083plan_es
planet84228353plan_et
planets93914083planets
planing103418253planing
planish12412053planish
plank115221143plan__k
planked143512283planked
planks124116753plan_ks
planned103810153planned
planner93511623planner
plans75731273plan__s
plant75437113plan__t
plantar9369993plantar
planted103516123planted
planter94017803planter
plantlet10310013plantlet
plants84921803plan_ts
planuloid1243483planuloid
plaque17317643plaqu_e
plaques18317893plaques
plasma103810913pla_sma
platina94413643platina
playa105812943pla__ya
playful1544653playful_
plaza164311063pla__za
plena75816393plen__a
plenum1039503plenu_m
plenums1136533plenums
pleura837533pl_eura
pliantly1345783pliantly
plugola1043013plugola
plumular1243303plumular
plumule1134303plumule
primula1145713primula
pula65129373p___ula
radula749313_radula
ranular739433_ranular
ranulas7311773_ranulas
scapula1136343scapula
slantly10399323slantly
spatula935893spatula
spinula9257903spinula
valvula1343253valvula
zonula1537223_zonula

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.423422437.4
2DLD Change Limit1340271326.03322215.6
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.50227482.5
 
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.