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

78 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
patiences136743(None) 
patience1247521patience_
faiences1337042fa_iences
impatiences1753702impatiences
patencies1349172pat_encies
patienter1145552patienter
patientest1245712patientest
patients1088762patien_ts
patines95225762pati_n_es
potences12710692pot_ences
saliences11108062saliences
sapiences13116422sapiences
absences1247673_absences
alienees8118653_alienees
ambiences1545253ambiences
audiences1246003audiences
cadences1338473ca_dences
faience1237513fa_ience_
impatience1653913impatience_
laitances1145613laitances
latencies1147773lat_encies
latices9313763lati__ces
leniences1148143leniences
matinees102110423mati_nees
nascences1346233nascences
outfences1456463outfences
painches1588913pa_i_nches
pangenes112612823pangen_es
parietes10714543parie_tes
parlances1348953parlances
parvenues1444643parvenues
patency1466313pat_enc_y
patens84820863pat_en__s
patented1188893pat_ented
patentee1099943pat_entee
patentees1196543pat_entees
patents94815203pat_en_ts
patient9617073patien__t
patiently1445633patiently
patinae95414403pati_nae_
patinaed11407833pati_naed
patinas96318523pati_n_as
patinates113814693patinates
patine85328123pati_n_e_
patined105114783pati_n_ed
patinizes20710333patinizes
patins87528783pati_n__s
patnesses111611793patnesses
pattened11299393patten_ed
pattens95414923patten__s
penitences1447973penitences
pertinences1545743pertinences
pestilences1544693pestilences
pieces104217273p__ie_ces
pierces113411193p__ierces
pittances1345703pittances
potence11711363pot_ence_
potencies1369303pot_encies
presences132113793presences
pretences132312613pretences
princes113015143p_ri_nces
prudences1446683prudences
pruriences1444703pruriences
radiances1247693radiances
ratines75328583rati_n_es
reticences1447453reticences
salience10117903salience_
saliencies1246133saliencies
sapience12106613sapience_
sapiencies1445123sapiencies
satieties939383satieties
sciences1238773_sciences
sentiences1247603sentiences
tangences1246443tangences
tierces93710453__tierces
valences1388513va_lences
valiances1487203valiances
variances14117363variances

Search took 9 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.420425454.8
2DLD Change Limit148641787.56319653.7
3Display Results78780.0332363.6
 (SQL Overall)178691788.01622291.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.