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

88 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
patentee109994(None) 
patented1188891patented
patentees1196541patentees
parented11912212parented
patent84524922patent__
patently1347112patently
patentor1046372patentor
patents94815202patent_s
patienter1145552patienter
pattee84323382pat__tee
absentee1067663absentee
agented939423_agented
attendee946403attendee
catenae9311373caten_ae
catenate10312833catenate
catenated1238913catenated
catenates11311813catenates
detente83313603detent_e
detentes92712873detentes
entente7412953entent_e
ententes8312773ententes
lamented1138193lamented
lamenter1038863lamenter
latened8711923laten_ed
latent64124303latent__
latently1146353latently
latents75214313latent_s
matinee92415613matin_ee
mentee84121293__mentee
painted104214633pa_inted
painter93814563pa_inter
paleate94120003paleat_e
palette93613983pale_tte
palettes103112833palettes
panted95024823pa__nted
pantie84326473pa__ntie
parent83230423parent__
parentage1245603parentage
parental10310943parental
parents93418123parent_s
patellae1047623patellae
paten74827343paten___
patencies1349173patencies
patency1466313paten_cy
patens84820863paten__s
patentable1444933patentable
patenting1248943patenting
patentors1146743patentors
patience1247523patien_ce
patiences1367433patiences
patient9617073patient__
patientest1245713patientest
patiently1445633patiently
patients1088763patient_s
patinae95414403patin_ae
patinaed11407833patinaed
patinate103016313patinate
patinated123911413patinated
patinates113814693patinates
patine85328123patin__e
patined105114783patin_ed
patines95225763patin_es
patinize19610773patinize
patootie1046303patootie
patted94724683pat__ted
patten84418193pat__ten
pattened11299393patten_ed
patter84628263pat__ter
pattie84020963pat__tie
pawnee113115403pa_wn_ee
pensee8417313p__ensee
pentene9313793p__entene
petuntse1042473petuntse
petuntze1942243petuntze
placentae1364353placentae
potence11711363poten_ce
potences12710693potences
potent84223353potent__
potentate1197253potentate
potently1347403potently
presentee11411863presentee
puttee85919723put__tee
talented938423talented
tented74221003__tented
tenter64623933__tenter
tentie62521183__tentie
testee64323303__testee
untented92613413untented

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.436409841.7
2DLD Change Limit146162887.37619815.9
3Display Results88880.0302933.3
 (SQL Overall)178691887.84222786.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.