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

60 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
patentor104637(None) 
patentors1146751patentors
patent84524922patent__
patented1188892patented
patentee1099942patentee
patently1347112patently
patents94815202patent_s
patienter1145562patienter
stentor739382_stentor
abettor956193_abettor
accentor12106133accentor
assentor865293assentor
attestor845463attestor
cantor85621523ca__ntor
caveator1387233caveator
detector11278323detector
extensor1543913extensor
indentor9288513indentor
inventor11298153inventor
lamenter1038863lamenter
latent64124303latent__
latently1146353latently
latents75214313latent_s
mentor8414363__mentor
painter93814563pa_inter
paletot9413713pale_tot
palpator1247133palpator
panto76129413pa__nto_
pantos85222743pa__ntos
parent83230423parent__
parental10310943parental
parented11912213parented
parents93418123parent_s
pastor84817483pa__stor
patellar1046863patellar
paten74827343paten___
patency1466313paten_cy
patens84820863paten__s
patentees1196553patentees
patenting1248943patenting
pater74740723pate___r
patient9617073patient__
patiently1445633patiently
patients1088763patient_s
patter84628263pat__ter
pawnor11357243pa_wn_or
pimento1157223pimento_
pimentos1246233pimentos
potent84223353potent__
potently1347403potently
praetor938973prae_tor
precentor1348733precentor
pretor8315753p_re_tor
protector13169533protector
protestor11178493protestor
stentors839753_stentors
stertor7310093_stertor
tenor53620253__ten_or
tensor63812673__tensor
tenter64623933__tenter

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.406440125.6
2DLD Change Limit146162607.04620744.0
3Display Results60600.0331818.2
 (SQL Overall)178691607.48523873.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.