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

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

111 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
presentence154639(None) 
presentenced1754041presentenced
presentences1655691presentences
resentence1248111_resentence
presentee11411862presente__e
resentenced1455172_resentenced
resentences1347422_resentences
nonsentence1355873nonsentence
persistence1554153persistence
precedence1746113prece_dence
preference1776983prefe_rence
prescience16157293pres_cience
presence122213513pres___ence
presentable1546033presentable
presented12311633presente__d
presentees1247923presente_es
presentencing1852503presentencing
presenter11311643presente__r
presenters1239863presente_rs
presentient1348323presentien_t
presenting131013023presentin_g
presentment1555673presentmen_t
presentments1654303presentments
presentness1345663presentness
pretence122312123pr__e_tence
provenience1853813provenience
repentance1456623_repentance
sentence1099863___sentence
subsentence1553533subsentence
dependence1646594_dependence
desinence1257504_desin_ence
insentience1355524_insentience
nonsentences1455704nonsentences
penitence1348094p_e_nitence
pentene9313794p___enten_e
permanence1654864perman_ence
persistences1653864persistences
persistency1852654persistency
pertinence1445834pertin_ence
pestilence1454544p_estilence
preannounce1551604preannounce
precedences1845514prece_dences
precedency2053694prece_dency
precented14310694precente__d
precenting151012154precentin_g
predestine1349324predestin_e
preemergence1962294preemergence
preeminence1763804preeminence
preexistence2352354preexistence
preferences1876184prefe_rences
prefinance1795444prefin_ance
prentice121012354pr__ent_ice
prepotency1953784pre_potency
presciences17127274pres_ciences
preselect1346984prese_le_ct
presences132113794presence__s
present94022734present____
presentably1855284presentably
presentative1755344presentative
presentiment1654454presentimen_t
presentiments1753024presentiments
presentism1447244present_ism
presentisms1555214presentisms
presentist12410094present_ist
presently1449064present__ly
presentnesses1554424presentnesses
presents103315644present___s
preservice1744484prese_rvice
presetting131010834presettin_g
presettle1145944prese_t_tle
presidency1844654pres_idency
presweeten1552594presweeten__
presweetened1871414presweetened
presweetens1651984presweeten_s
pretences132312614pr__e_tences
pretense10199824pr__e_tense
prevalence1745484pre_valence
prevenient1547814prevenien_t
preventable1844984preventable
prevented1539004prevente__d
preventer1438594prevente__r
preventers1547394prevente_rs
preventible1854424preventible
preventing161210264preventin_g
preventive1847544prevent_ive
prominence1644924promin_ence
provenance1744484proven_ance
proveniences1953674proveniences
reentrance1245464_re_entrance
reference14810094_refe_rence
remanence1346714_reman_ence
renitence1149054_re_nitence
repentances1556114_repentances
resented92716964_resente__d
resentencing1563014_resentencing
resenting102619294_resentin_g
resentive12410724_resent_ive
resentment1248084_resentmen_t
resentments1346544_resentments
residence1268904_res_idence
resilience1265624_resilience
resistance1245884_resistance
resonance1147624_reson_ance
resplendence17112924_resplendence
resurgence1345494_resurgence
reverence14710164_reve_rence
sentenced1256684___sentenced
sentencer1156384___sentencer
sentences11610304___sentences
sentience1147664___sentience
subsentences1653604subsentences

Search took 10 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 Filter1786911488190.453394461.4
2DLD Change Limit1488191118.92316678.1
3Display Results1111110.0462413.0
 (SQL Overall)1786911119.42218965.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.