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

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

54 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
regolith124754(None) 
regoliths1344111regoliths
aerolith1149832aerolith
eolith93013902_e_olith
megalith1448242megalith
neolith1068782ne_olith
regality1249312regality
repolish1347932repolish
xenolith1845652xenolith
acrolith1348453acrolith
aerolite8315053aerolite
aeroliths1245643aeroliths
demolish1447833demolish
depolish1446943depolish
egalite8311563_egalite
eoliths10318573_e_oliths
goliath1145933__goliath
granolith1345273granolith
kryolith1843213kryolith
legality1237623legality
megaliths1544743megaliths
monolith1349673monolith
neoliths1144933ne_oliths
oolith93813243__oolith
otolith10108283_otolith
pisolith1346553pisolith
reality10313573re_ality
regalia839223regali_a
regaling10315363regaling
regelate9312083regelate
regilt71217493regil_t_
reglet73724233reg_let_
reglets83512983reg_lets
regrowth1544033regrowth
regulate9313023regulate
reguli738143reguli__
reguline939503reguline
relish93916953re__lish
relit55340683re__lit_
reposit9315863reposit_
reposits10310453reposits
resoling92916303resoling
resolute868513resolute
resplit9310373resplit_
resplits1037723resplits
revolt9316223revol_t_
revolts1038893revol_ts
revolute1176793revolute
rhyolite1445513rhyolite
rugosity1243733rugosity
tremolite1156893tremolite
urolith1048783_urolith
xenoliths1943313xenoliths
zeolite1638903ze_olite

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.406440125.6
2DLD Change Limit146162546.57622226.6
3Display Results54540.0331636.4
 (SQL Overall)178691547.01525472.7
 
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.