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

56 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
regrooming146416(None) 
regrooving1553501regrooving
beglooming1642952beglooming
grooming12309512__grooming
reblooming1543422reblooming
regrouping1443692regrouping
regrowing1436672regr_owing
reroofing1336862re_roofing
begriming1545533begr_iming
begrimming1842573begrimming
begroaning14114113begroaning
brooming132911143__brooming
enrooting10128133_enrooting
glooming12358013__glooming
grooving13286713__grooving
pogroming1544733pogr_oming
rearming111413613rear__ming
rearousing1156453rearousing
rebooking16146393re_booking
rebooting12139023re_booting
rechoosing1645373rechoosing
recooking16148543re_cooking
recrossing1386973recrossing
recrowning1645213recrowning
redreaming1446443redreaming
reflooding1544053reflooding
reforming1538563re_forming
reframing1538623refr_aming
refronting1437273refronting
reglossing1244163reglossing
reglowing1436173reg_lowing
regorging1236823reg_orging
regrading121210203regr_ading
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regr_ating
regreening1246033regreening
regreeting1237343regreeting
regressing1248143regressing
regretting1237783regretting
regrinding1335703regrinding
regroom1077303regroom___
regroomed1344153regroom_ed
regrooms1196013regroom__s
relooking14167143re_looking
reprobing1438073repr_obing
reproving1538413repr_oving
rerolling102210373re_rolling
rerouting10311873re_routing
reshooting1436223reshooting
respooling1355743respooling
retooling1039093re_tooling
retrimming1544263retrimming
rooming104117043___rooming
varooming1545083_varooming
vrooming14287353__vrooming

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 Filter1786911406030.423422437.4
2DLD Change Limit140603568.25017042.8
3Display Results56560.060933.3
 (SQL Overall)178691568.73320461.6
 
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.