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

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

127 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
regality124931(None) 
legality1237621legality
reality10313571re_ality
egalite8311562_egalite
frugality1653272frugality
megacity1645712megacity
megalith1448242megalith
penality13310712penality
realty92713692re_al_ty
regalia839222regali_a
regaling10315362regaling
regally1159872regal_ly
regolith1247542regolith
rurality1137402rurality
venality1438682venality
agility1148653_agility
anality10313633_anality
aurality1139223aurality
axiality1856763axiality
banality1338763banality
brutality1444123brutality
coevality1745383coevality
credulity15123833credulity
debility1448643debility
dentality1348473dentality
duality1147973_duality
edacity1336373_edacity
egalites9310503_egalites
equality2046993equality
fatality1438443fatality
fealty122910223fe_al_ty
feracity1646733feracity
feudality1654403feudality
finality1448343finality
fragility1645563fragility
fugacity1743323fugacity
geniality1347163geniality
ideality1247153ideality
illegality1473223illegality
irreality1245413irreality
lealty92910603le_al_ty
legalise949493legalise
legalism1148583legalism
legalist9512393legalist
legalists1047943legalists
legalize1839103legalize
legally1138133legal_ly
legerity1245713legerity
lethality1545113lethality
locality13148433locality
megabit12117963megabit_
megabits1355793megabits
megahit1378773megahit_
megahits1445683megahits
megaliths1544743megaliths
mentality1449133mentality
modality14117653modality
molality13118363molality
morality131110333morality
nasality1146653nasality
natality1139193natality
nodality12127423nodality
orality101111683_orality
ovality1377593_ovality
penalty1267743penal_ty
predacity1745603predacity
primality1687333primality
quality1938563_quality
rapacity1544983rapacity
rarity93615493r__arity
rascality1445993rascality
readily11711403re_adily
realia6314593re_ali_a
realign838763re_align
realise73021813re_alise
realism93115923re_alism
realist73225383re_alist
realists83014843re_alists
realize162717083re_alize
really93315613re_al_ly
rebait8320403reba_it_
rebaits9312583reba_its
regain74517763rega_i_n
regains84316583rega_ins
regal65023793regal___
regale74821453regal__e
regaled93615963regal_ed
regaler83814623regal_er
regalers94311133regalers
regales83520793regal_es
regalities11410593regalities
regatta835963rega_tta
regelate9312083regelate
regilt71217493regil_t_
reglet73724233reg_let_
reglets83512983reg_lets
regoliths1344113regoliths
regularity1454043regularity
regulate9313023regulate
reguli738143reguli__
reguline939503reguline
relit55340683re__lit_
repacify1843483repacify
requalify2443073requalify
resalute857413resalute
resplit9310373resplit_
resplits1037723resplits
retaliate9410643retaliate
retally10413683retal_ly
rigidity1345263rigidity
royalty13165113royal_ty
rugosity1243733rugosity
ruralite848963ruralite
sagacity1445243sagacity
sedulity1245843sedulity
senility1139683senility
sexuality1946073sexuality
sodality12127323sodality
tenacity1347113tenacity
tonality1139793tonality
totality1139373totality
unreality1246323unre_ality
vagility1546323vagility
veniality1547593veniality
veracity1647553veracity
vitality1458113vitality
vocality16137933vocality

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621277.23320207.7
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.71923149.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.