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 “pontes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

155 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
pontes8362785(None) 
contes84432911contes
montes84226931montes
pointes93216751pointes
ponces104720841ponces
pones74547041pon_es
ponies84833461ponies
antes56334322_antes
boites84322702boites
bones76446532bon_es
bonnes85621452bonnes
bonzes175116102bonzes
comtes106222812comtes
cones76457422con_es
conges94928172conges
conies84338592conies
conte76633202conte_
contest93523232contest
contos84923232contos
cotes76347842co_tes
donates83217222donates
donees74519492donees
dotes65836692do_tes
fonts86124752font_s
fortes95327182fortes
frontes104214162frontes
gentes75324162gentes
hones88144492hon_es
jones125028182jon_es
kentes105118642kentes
longes75925572longes
lottes65322752lottes
mantes84430782mantes
mondes94322352mondes
monies83233162monies
monte75829772monte_
months113812932months
motes75944002mo_tes
mottes85523692mottes
nonces84418832nonces
nones55639132non_es
nonets64118702nonets
notes55034582no_tes
ones46146532_on_es
panes76148692pan_es
pannes85522852pannes
panted95024822panted
panties94230932panties
pantos85222742pantos
pants76536922pant_s
pastes85233912pastes
pates76047892p_ates
penates93321592penates
penes75839222pen_es
peones83821042peon_es
peonies93620152peonies
phonates13410642phonates
phones114121212phon_es
phonies123717512phonies
pines76048862pin_es
pinites9319532pinites
pintas85021392pintas
pintles94118722pintles
pintoes95117712pintoes
pintos86021292pintos
pints75936222pint_s
pistes85325632pistes
plates85432242plates
podites103014732podites
poetess938932poetess
poets76024442poet_s
pogies94123542pogies
pointe84619312pointe_
pointed103813982pointed
pointer93814932pointer
pointers103013722pointers
points85618532point_s
poises84226542poises
pokes116133012po_kes
pokies125921332pokies
poles75351002po_les
polies84034582polies
pomes94833932po_mes
ponce95222512ponce_
ponced114314812ponced
ponded105218772ponded
ponder94521692ponder
ponders103618842ponders
ponds85323402pon_ds
pone65747532pon_e_
ponged105619352ponged
pongee94920192pongee
pongees104212542pongees
pongs85526342pon_gs
ponied94920702ponied
pons65850602pon__s
pontil8315462pontil
pontils9312212pontils
ponton83217642ponton
pontons93315552pontons
pooves113914712pooves
popes95933812po_pes
pores75849032po_res
ported94223242ported
porter84224412porter
porters93722702porters
ports75934592port_s
poses74642762po_ses
posies84431432posies
posses85128802posses
posted93722492posted
poster84129172poster
posters93928012posters
posties93128812posties
posts75228782post_s
pots66452362po_t_s
potted94624012potted
potter83926982potter
potters94024342potters
potties93723542potties
pottles93816982pottles
pottos84615872pottos
pounces114113892pounces
pouted94021392pouted
pouter83923982pouter
pouters94221872pouters
pouts75530322pout_s
powter114116032powter
powters124015662powters
poxes145325722po_xes
prates84633162prates
pronates10418372pronates
punted94618712punted
punter84320022punter
punters93617042punters
punties94520782punties
puntos85915792puntos
punts75828002punt_s
rentes65431192rentes
rotes56143902ro_tes
rottes64524832rottes
routes66129312routes
sondes74922872sondes
sones55444142son_es
sponges10311042sponges
tones56048662ton_es
tonnes65320852tonnes
tortes64826052tortes
totes55139682to_tes
voltes94915582voltes
votes84627082vo_tes
wonted103213282wonted
wonts87621542wont_s
yentes95517602yentes
zones145528042zon_es

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511552.50033020.4
3Display Results1551550.0463369.6
 (SQL Overall)1786911552.65667278.2
 
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.