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

68 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
plumbness154313(None) 
plumpness1543471plumpness
dumbness1334612_dumbness
glumness1135202glum_ness
numbness1234412_numbness
plumbers14418512plumb_ers
plumbnesses1753072plumbnesses
plushness1444622plushness
alumines10411683alumine_s
blueness1038213blu_eness
bluffness1742503bluffness
bluntness1144343bluntness
clubbiness1642993clubbiness
clumbers143910413clumb_ers
clumsiness1444333clumsiness
fluidness1344293fluidness
flukiness1635453flukiness
flushness1544893flushness
glibness1134133gl_ibness
glueyness1342913glueyness
gluiness937363glu_iness
lameness102612673_lameness
limbless12246313_limbless
liminess10510643_liminess
limpness1246703_limpness
lumbers113815913_lumb_ers
lumpiness1336483_lumpiness
lushness1136233_lushness
plainness1155183plainness
planeness1138153planeness
pluckiness1883823pluckiness
plugless1133863plu_gless
plumages1335653plumage_s
plumbagos1641673plumbagos
plumbed14317273plumb_e_d
plumbeous1542903plumbeous
plumber13339983plumb_e_r
plumbery17315533plumb_ery
plumbings16213363plumbings
plumbism1643813plumb_ism
plumbisms1742943plumbisms
plumbous1444283plumb_ous
plumbs12459333plumb___s
plumbums1642943plumb_ums
plumelets1372823plumelets
plumes104318133plum__e_s
plumiest122110293plum_iest
plumipeds1641663plumipeds
plummest14276413plum_mest
plummets14304773plum_mets
plummiest1544973plummiest
plumpens14304953plum_pens
plumpers14357293plum_pers
plumpest14236353plum_pest
plumpnesses1753263plumpnesses
plumules1234663plumule_s
plushiness1544093plushiness
primeness1338653primeness
primness1276763prim_ness
pulpiness1335603pulpiness
pumpless14236373p_umpless
puniness101610273p_uniness
pureness101110183p_ureness
sliminess1137423sliminess
slimness1036523slim_ness
slumbers123110273slumb_ers
snubness1044373snu_bness
thumbless1643423thumbless

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641687.51619776.6
3Display Results68680.0332060.6
 (SQL Overall)178691687.70523191.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.