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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
primula114571(None) 
primulas1246131primulas
prima95019342prim__a
primal104014622primal_
primely1457722primely
primly13439622prim_ly
primus103712172primu_s
acicula11228133acicula
armilla936993armilla
arugula843913arugula
auricula1045803auricula
brimful1443883brimful_
brimfull1542543brimfull
chimla1337593chim_la
crimple13408693crimple
fibula11258053_fibula
formula1246293formula
frenula1045623frenula
grimily1336523grimily
grimly12459933grim_ly
ligula7359673_ligula
limuli836343_limuli
papula103011123p_apula
perilla9311233peri_lla
picul95015363p_icul_
piculs103511753p_iculs
pilular938203p_ilular
pilule8411123p_ilule
pima85428663p_im__a
pimple123512963p_imple
pimply15329213p_imply
pinnula934923pinnula
planula935773planula
plumular1243303plumular
plumule1134303plumule
premeal11310523premeal
premolar1246633premolar
premold1247863premold
premolt11312073premolt
premune1138933premune
prepupa1064023prepupa
pricily142710283pricily
prickle153611013prickle
prickly18367893prickly
prill74117943pri__ll
prills84015613pri_lls
prim85132203prim___
primacy1635603primacy
primage12169143primage
primary1437703primary
primas104418103prim_as
primatal1247133primatal
primate111516283primate
prime96525603prim__e
primed115118913prim_ed
primer105118683prim_er
primero11368923primero
primers114215673primers
primes104225263prim_es
primeval1544103primeval
primi95017403prim__i
primine113214823primine
priming123417373priming
primmed14388853primmed
primmer134310163primmer
primo95017913prim__o
primos104514423prim_os
primp115615923prim__p
primped14479153primped
primps124711823prim_ps
prims95425933prim__s
primsie1137543primsie
primuses1237083primuses
priorly12335763priorly
privily15207623privily
promulge1343043promulge
propyla14296633propyla
pruta7314243pr__uta
pula65129373p___ula
radula749313_radula
rambla103510933_rambla
ranula6311813_ranula
remuda936823_remuda
rimple103814583_rimple
ritual6310623_ritual
simular938683_simular
spicula11259303spicula
spinula9257903spinula
spirula9257703spirula
stimuli944513stimuli
trimly114410893trim_ly

Search took 8 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.406440125.6
2DLD Change Limit134027916.68620045.9
3Display Results91910.0332757.6
 (SQL Overall)178691917.12525079.4
 
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.