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

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

92 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
reformatories186255(None) 
reformates1546263reformat___es
reformatory19123443reformator__y
refractories1754503ref_ractories
crematories1546864cre___matories
deformities1744284deformit__ies
dormitories1463674__dormitories
fumatories1544744__f_umatories
informatorily2161584informatorily
laboratories1482314labor_atories
oratories9410654___or_atories
refectories1646434ref__ectories
reformate1446954reformat___e_
reformation1648414reformat__ion
reformations1747604reformat_ions
reformative1945674reformat__ive
reformats1445714reformat____s
reformatted1752624reformat__ted
reformatting1852704reformat_ting
refortifies1753774refor__tifies
repertories1355834reper__tories
repositories1453884repo_sitories
aerometries1348395aero_met_ries
decorators1347875decor_ator__s
defoliators1543725defoliator__s
deformalizes2754875deforma_lizes
deformation1747665deformat__ion
deformations1846845deformat_ions
deformative2044975deformat__ive
depilatories1552985de_pilatories
depositories1553165depo_sitories
dermatomes1544305de__rmato_mes
dermatoses1344965de__rmato_ses
dermatosis1354945de__rmatosi_s
effronteries1861895_effronteries
enormities1246905_enormit__ies
ergometries1455685ergo_met_ries
excretories2052905_excr_etories
feretories1348605__fer_etories
feudatories1553715__feudatories
forestries1348555__forest_ries
formalities16137825__formalities
formates132814295__format___es
formatives1846215__format_ives
formicaries1853645__formicaries
formularies1654165__formularies
fumitories1544065__f_umitories
geometries13139255ge_o_met_ries
hermitries1546765he__rmit_ries
herstories1348605he__r_stories
infirmaries1652995infirma__ries
informalities1864295informalities
informatics1854105informat__ics
informatory1953465informator__y
observatories1861675observatories
offertories1752655offer__tories
oratorios944925___or_atorios
perforators1644855perfor_ator__s
performatives2392685performat_ives
performatory2252585performator__y
perorators1249355peror_ator__s
preformation1946475preformat__ion
preformationist2272225preformationist
preformations2045715preformat_ions
preformats1744415preformat____s
preformatted2052275preformat__ted
preformatting2152075preformat_ting
purgatories1463335__purgatories
rectories11314655re____ctories
reflectorizes2773545ref_lectorizes
reformabilities2264535reformabilities
reformability2354645reformability
reformable1745295reforma__ble_
reformat1357655reformat_____
reformational18113425reformational
reformers14246405reform__er__s
reformulates1752985reform_ulates
refortified1853445refor__tified
refractorily2062525ref_ractorily
refractoriness1962225ref_ractoriness
refractors15156275ref_ractor__s
remarries1147675re___ma_rries
renovators1344845reno_vator__s
repertoires1352655reper__toires
reportorial1353625repor__torial
resonators1045815reso_nator__s
rotatores946485r__o_tator_es
secretories1345945se_cr_etories
termitaries1345695te__rmitaries
territories1146025te__rritories
vomitories1544905__vo_mitories
yeomanries1543705ye_o_ma_nries

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 Filter1786911247900.393454684.5
2DLD Change Limit124790928.87314064.0
3Display Results92920.0631460.3
 (SQL Overall)178691929.32919154.4
 
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.