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

58 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
upholders154364(None) 
upholder1444081upholder_
beholders1544932beholders
coholders1535622coholders
holders113715902__holders
inholders1345352inholders
polders103617372_p_olders
unfolders1344722unfolders
unsolders1064692unsolders
upholds13135242uphold__s
upholsters1542732upholsters
beholder1435053beholder_
cholers124215203_chol_ers
chowders17387543_chowders
coholder1436073coholder_
copyholders2252173copyholders
enfolders1395093enfolders
folders113514393__folders
gasholders1543803gasholders
holder104619653__holder_
hollers103818233__hollers
infolders1385173infolders
inholder1276113inholder_
jobholders2352173jobholders
molders103315553__molders
penholders1643793penholders
pewholders1942703pewholders
philters1398173_philters
plodders1235523_plodders
polder94019253_p_older_
polers84225643_p_ol_ers
pollers93420023_p_ollers
ponders103618843_p_onders
poolers94217423_pool_ers
potholders1644343potholders
powders134111553_p_owders
prodders1237463_prodders
resolders10258013resolders
scolders11288993_scolders
shoulders1334233_shoulders
smolders11287193_smolders
solders83517773__solders
spoolers10349363spool_ers
unfolder12216583unfolder_
unholier1137283unholier_
unloaders1044403unloaders
unsolder937213unsolder_
upbuilders1551353upbuilders
upfolded1542883upfolde_d
upfolds13133753upfold__s
upheavers1742593upheavers
uphold12126903uphold___
upholding1643373upholding
upholster1442683upholster_
upholstery1851853upholstery
uplanders1234853uplanders
uprooters1164253uprooters
uptowners1441933uptowners

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.436409841.7
2DLD Change Limit148641586.98621277.0
3Display Results58580.0134461.5
 (SQL Overall)178691587.43524033.8
 
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.