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

111 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
plumule113430(None) 
plumules1234661plumules
lunule638432_lunule
plumage1245502plumage
plumate1149802plumate
plume94819462plum__e
plumelet1276172plumelet
plumose1135962plumose
plumply1634222plumply
plumular1243302plumular
plumulose1341772plumulose
almuce10348213al_muce
almude9399933al_mude
alumine9412693alumine
alumnae955403alumnae
blume95619893blum__e
bumble124216893_bumble
crumble133410403crumble
crumple13368363crumple
cumuli1036273_cumuli
cupule103410723_cupule
curule83614123_curule
drumble12337893drumble
flume106021173flum__e
fumble133214263_fumble
fumuli1135263_fumuli
gemmule12173233gemmule
globule1034383globule
glume85120463glum__e
glumly12356623glum_ly
grumble12349233grumble
humble133615053_humble
jumble174012653_jumble
ligule74010833_ligule
limuli836343_limuli
lobule82910063_lobule
locule83412033_locule
lunula636173_lunula
lunulae735613_lunulae
lunules738953_lunules
mule65236973___mule
mumble123614343_mumble
mutule8311423_mutule
papule102212133p_apule
permute1138793permute
pilule8411123p_ilule
pimple123512963p_imple
pinnule936003pinnule
plague93610853plagu_e
planula935773planula
planulae1044793planulae
plaque17317643plaqu_e
pliable111610323pliable
plimsole1243663plimsole
plugola1043013plugola
plugugly1541123plugugly
plum85122103plum___
plumaged1443573plumaged
plumages1335653plumages
plumb114514073plum__b
plumbable1743323plumbable
plumbed14317273plumbed
plumber13339983plumber
plumbic1543963plumbic
plumbs12459333plum_bs
plumbum1543733plumbum
plumbums1642943plumbums
plumed114412883plum_ed
plumelets1372823plumelets
plumes104318133plum_es
plumier113510043plumier
pluming123412043pluming
plumiped1533313plumiped
plumlike1643793plumlike
plummer13298523plummer
plummet13278353plummet
plummier1434123plummier
plummy15375663plum_my
plump115315263plum__p
plumped14318643plumped
plumpen13276403plumpen
plumper13318773plumper
plumps124612613plum_ps
plums94619953plum__s
plumy124213233plum__y
plunge93811053plu_nge
plural839823plural_
plurals936913plurals
plushly15385383plushly
premune1138933premune
primula1145713primula
promulge1343043promulge
puddle103914153p_uddle
pule65040953p___ule
pulque1736213pulqu_e
pumelo10257113p_umelo
pumice1238223p_umice
pummel12278043p_ummel
pungle94413573p_ungle
purfle112511183p_urfle
purple102712683p_urple
pustule937683pustule
puzzle16318603p_uzzle
rumble103718813_rumble
rumple103913013_rumple
scumble1337013scumble
stumble1147553stumble
tubule839853_tubule
tumble103215643_tumble
tumuli835933_tumuli
tumult839703_tumult

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.406440125.6
2DLD Change Limit1340271116.50020619.5
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.95225703.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.