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

138 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
repentances155611(None) 
repentance1456621repentance_
dependances1754852dependances
reentrances1345172re_entrances
resentences1347422resentences
dependance1645123dependance_
dependences1745883dependences
expectances2493343expectances
penances12312443__pen_ances
pentanes10316083__pentan_es
presentences1655693presentences
reactances1446143re_actances
reentrance1245463re_entrance_
refinances15107133refin_ances
reflectances1952643reflectances
relevances1596113rele_vances
reluctances15143933reluctances
remittances1554003remittances
repentant1149323repentan__t
repentantly1653323repentantly
reprobances1754133reprobances
repugnances1692863repugnances
resentence1248113resentence_
resentenced1455173resentenced
resistances1345373resistances
resonances1246873reson_ances
acceptances1653174acceptances
appearances1753694appearances
appetences1644594appe_tences
ascendances16123834ascendances
attendances1483194attendances
defeasances1752284defeasances
dependants1444704dependan_ts
dependence1646594dependence_
dependencies1854084dependencies
desistances1444194desistances
edentates1046954_edenta_tes
elegances1246184_ele_gances
emittances1443824_emittances
enhances1339294___enhances
entrances11310954___entrances
epentheses1563804_epentheses
esperances1446254espe_rances
expectance2363624expectance_
expectancies2562244expectancies
exultances19133284_exultances
freelances1545224fre_e_lances
happenstances2261154happenstances
heptanes1339004hep__tan_es
hesitances1545544he_sitances
impedances1744504impe_dances
impenitences1854024impenitences
importances1754294importances
intendances1445564intendances
nepenthes1444164nepent__hes
penance11313444__pen_ance_
penanced1338164__pen_anced
penetrances1544804penetrances
penitences1447974__penitences
pentacles1338774__pentacles
pentane9415744__pentan_e_
pentangles1344834__pentangles
pentanols1146114__pentanols
pentarchs1643934__pentarchs
pentenes10315634__penten_es
pittances1345704__pittances
portances1349834__portances
prefinances1875014prefin_ances
presentence1546394presentence_
presentenced1754044presentenced
provenances1854534proven_ances
reactance1346354re_actance_
reappearances1961774reappearances
rebalances1445254re_balances
recentness1245464recent_ness
receptacles1752394receptacles
recontacts1444904reconta_cts
reconvinces1844954reconvinces
recreances1446504re_creances
redundancies1651954redundancies
reenacts1036994re_en_a_cts
reenforces1543494re_enforces
reengages1145344re_enga_ges
reenlarges1143124re_enlarges
reentrants1044664re_entran_ts
reentries9311764re_ent_ries
refences13311844refe___nces
references1589354refe_rences
refinance14117644refin_ance_
refinanced16144764refin_anced
reflectance1852864reflectance_
regnancies1345414re_gn_ancies
relevance14146444rele_vance_
relevancies1654334rele_vancies
reliances1139624r__eliances
reluctance14114284reluctance_
reluctancies16122454reluctancies
remanences1446624reman_ences
remembrances20152894remembrances
remittance1444454remittance_
remonstrances1752994remonstrances
remontants1245044remontan_ts
renitences1248444re_nitences
renounces1147544r__enounces
repeatable1447604repeatable_
repechages1843274repecha_ges
repellants1244174repellan_ts
repellencies1663074repellencies
repented112614984repent___ed
repenter102813864repent___er
repenters112511554repent__ers
repenting122316554repentin__g
repents93717624repent____s
repertoires1352654repertoires
repertories1355834repertories
repetends1244004repe_ten_ds
replaces123114124rep__la_ces
reportages1344384reporta_ges
reprobance1654094reprobance_
repugnance1573084repugnance_
repugnancies1752084repugnancies
rerebraces1445034rerebra_ces
resemblances1892214resemblances
resistance1245884resistance_
resonance1147624reson_ance_
respectables1873034respectables
resplendences18122384resplendences
revenants1246174reven_an_ts
reverences1579174reve_rences
revertants13124954revertan_ts
ropedancer15132524rope_dancer
ropedancers16101744rope_dancers
sentences11610304__sentences
serpentines1355294serpentin_es
severances1546784seve_rances
temperances1754734tempe_rances
tendances1247574__tendances
wapentakes1952254wapenta_kes

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191388.32617874.0
3Display Results1381380.0632190.5
 (SQL Overall)1786911388.81220278.1
 
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.