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

71 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
johnnies187299(None) 
johnnie1772281johnnie_
jennies143511622j_ennies
joannes1436242joann_es
johannes1842942johannes
sonnies7315222so_nnies
bennies93917313_bennies
blennies1056933blennies
bonnes85621453bo_nn_es
bonnie85314853bo_nnie_
bonnier94711313bo_nnier
bonniest10310773bo_nniest
boonies93422483bo_onies
botanies10312853botanies
bounties10311403bounties
bunnies94415003_bunnies
cohunes1249713cohun_es
colonies103620013colonies
conies84338593co__nies
conines93827793co_nines
connives1339723co_nnives
coonties10513803coonties
counties10316283counties
crannies10313013crannies
dominies113513193dominies
donnees84210363do_nnees
fannies103415643_fannies
funnies104113603_funnies
goonies83618333go_onies
grannies9312613grannies
gunnies83413123_gunnies
hinnies103615103_hinnies
hominies133012953hominies
hongies112716473ho_ngies
honkies143015143ho_nkies
jinnis13489053j_inni_s
jobnames1942903jobnames
johnny1932193johnn__y
johns15398713joh_n__s
johnsons1842383johnsons
joineries1648103joineries
joinings16285243joinings
jollies143516273jo_llies
jones125028183jo__n_es
joneses1438963jo_neses
jounces16369853jo_unces
jouncier1734423jouncier
jounciest1844613jounciest
joyances2044413joyances
junkies183711693j_unkies
longies82916553lo_ngies
loonies73919543lo_onies
minnies93617363_minnies
monies83233163mo__nies
nannies73015203_nannies
ninnies73713613_ninnies
oogenies9311583oogenies
pennies94218813_pennies
phonies123717513_phonies
pinnies93318443_pinnies
ponies84833463po__nies
shannies113411263shannies
shinnies113010913shinnies
spinnies103210543spinnies
tennies73017973_tennies
tonnes65320853to_nn_es
toonies73719883to_onies
townies103113623to_wnies
trannies8415013trannies
tunnies73614263_tunnies
whinnies14237273whinnies

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 Filter1786911461620.453394461.4
2DLD Change Limit146162716.92021121.7
3Display Results71710.0164437.5
 (SQL Overall)178691717.38924183.4
 
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.