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

75 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
upholder144408(None) 
upholders1543641upholders
beholder1435052beholder
coholder1436072coholder
holder104619652__holder
inholder1276112inholder
polder94019252_p_older
unfolder12216582unfolder
unholier1137282unholier
unsolder937212unsolder
upfolded1542882upfolded
uphold12126902uphold__
upholds13135242uphold_s
upholster1442682upholster
beholden1443593beholden
beholders1544933beholders
bolder94820933__bolder
choler113717153_chol_er
chowder16387813_chowder
coholders1535623coholders
colder95121853__colder
copyholder2152253copyholder
enfolder1286153enfolder
folder104317543__folder
gasholder1443823gasholder
golder84417603__golder
holden104113953__holden
holders113715903__holders
holier94921623__holier
holler93520613__holler
infolder1256433infolder
inholders1345353inholders
jobholder2242243jobholder
molder93819273__molder
older65121173___older
penholder1544413penholder
pewholder1842723pewholder
philter12108213_philter
phonier122710633_phonier
plodder1146003_plodder
polders103617373_p_olders
poler74431793_p_ol_er
poller83921853_p_oller
ponder94521693_p_onder
pooler83819843_pool_er
potholder1544763potholder
powder123611903_p_owder
prodder1147953_prodder
prouder10310383_prouder
resolder9259233resolder
scolder103210343_scolder
shoulder1234753_shoulder
smolder10327753_smolder
solder73921343__solder
spooler93711383spool_er
unfolded1338313unfolded
unfolders1344723unfolders
unhooded13277873unhooded
unloader936643unloader
unmolded1237453unmolded
unsolders1064693unsolders
upbuilder1441573upbuilder
upfold12124953upfold__
upfolds13133753upfold_s
upheaver1643443upheaver
upheld12115563upheld__
uphoarded1662273uphoarded
upholding1643373upholding
upholsters1542733upholsters
upholstery1851853upholstery
uphove1436133upho_ve_
uplander1145533uplander
uploaded1234533uploaded
uprooter1085243uprooter
uptowner1342043uptowner

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 Filter1786911461620.420425454.8
2DLD Change Limit146162756.51622431.2
3Display Results75750.0302500.0
 (SQL Overall)178691756.96625651.9
 
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.