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 “presentences” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
presentences165569(None) 
presentence1546391presentence_
presentenced1754041presentenced
resentences1347421_resentences
presentees1247922presente__es
resentence1248112_resentence_
resentenced1455172_resentenced
nonsentences1455703nonsentences
persistences1653863persistences
precedences1845513prece_dences
preferences1876183prefe_rences
presciences17127273pres_ciences
presences132113793pres___ences
presentee11411863presente__e_
presentencing1852503presentencing
presenters1239863presente__rs
presentments1654303presentmen_ts
presentness1345663present_ness
presentnesses1554423presentnesses
pretences132312613pr__e_tences
proveniences1953673proveniences
repentances1556113_repentances
sentences11610303___sentences
subsentences1653603subsentences
dependences1745884_dependences
desinences1347214_desin_ences
insentiences1455464_insentiences
mesenteries1345894_mesenteries
nonsentence1355874nonsentence_
penitences1447974p_e_nitences
pentenes10315634p___enten_es
permanences1754494perman_ences
persistence1554154persistence_
persistencies1752564persistencies
pertinences1545744pertin_ences
pestilences1544694p_estilences
preannounces1651574preannounces
precedence1746114prece_dence_
precedencies1953724prece_dencies
predestines1446994predestin_es
preeminences1883524preeminences
preexistences2462034preexistences
preference1776984prefe_rence_
prefinances1875014prefin_ances
prentices131111904pr__ent_ices
prepotencies1884294pre_potencies
presbyteries1952574presbyteries
prescience16157294pres_cience_
preselects1464364prese_le_cts
presence122213514pres___ence_
presentable1546034presentable_
presented12311634present___ed
presenter11311644present___er
presentient1348324presentien__t
presentiments1753024presentimen_ts
presenting131013024presentin__g
presentisms1555214present_isms
presentment1555674presentmen__t
presents103315644present____s
presettles1245024prese_t_tles
presidencies1754484pres_idencies
presweetened1871414presweeten_ed
presweetens1651984presweeten__s
pretence122312124pr__e_tence_
pretenses112210594pr__e_tenses
prevalences1845094pre_valences
preventers1547394prevente__rs
preventives1945724prevent_ives
prominences1744864promin_ences
provenances1854534proven_ances
provenience1853814provenience_
reentrances1345174_re_entrances
references1589354_refe_rences
remanences1446624_reman_ences
renitences1248444_re_nitences
repentance1456624_repentance_
resentencing1563014_resentencing
resentments1346544_resentmen_ts
residences1368234_res_idences
resiliences1375244_resiliences
resistances1345374_resistances
resonances1246874_reson_ances
resplendences18122384_resplendences
resurgences1445004_resurgences
reverences1579174_reve_rences
sentence1099864___sentence_
sentenced1256684___sentenced
sentencer1156384___sentencer
sentencers1274784___sentencers
sentiences1247604___sentiences
subsentence1553534subsentence_

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 Filter1786911247900.1531167915.0
2DLD Change Limit124790917.11017551.3
3Display Results91910.0631444.4
 (SQL Overall)178691917.32624391.3
 
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.