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

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
gloomings1328397(None) 
gloamings13254091gloamings
glooming12358011glooming_
bloodings13245272bloodings
blooming13299432blooming_
floorings13245092floorings
gloaming12268012gloaming_
glomming14275922glomming_
gloominess1343832gloominess
grooming12309512grooming_
looming102814852_looming_
becomings1643783becomings
beglooming1642953beglooming_
bloggings14264263bloggings
blooding122410653blooding_
blooping13248843blooping_
bookings15358733_bookings
booming123716223_booming_
brooming132911143brooming_
chromings17286093chromings
clonings11307433cl_onings
closings11277673cl_osings
clothings15264433clothings
coamings13349293_coamings
colorings1247683colorings
comings124013533__comings
cookings15358603_cookings
dooming113112533_dooming_
flockings19314343flockings
floggings15314123floggings
flooding13238963flooding_
flooring12259883flooring_
footings12248833_footings
gamings114610913g__amings
ghostings1433483ghostings
glazings19325753gl_azings
gleaming12277933gleaming_
gleanings11244643gleanings
gleyings13283653gl_eyings
gliming113310133gl_iming_
gloating102611463gloating_
globing113210003gl_obing_
globins10278953gl_obin_s
glonoins955843glonoin_s
gloomier1135093gloomi_er
gloomiest1235603gloomiest
gloomily1443753gloomi_ly
glooms96211683gloom___s
glopping14307753glopping_
glorying1335543glorying_
glossinas10214143glossinas
glossing10278883glossing_
glouting10379693glouting_
gloving12308443gl_oving_
glowing123211793gl_owing_
glozing18338893gl_ozing_
godlings11367493g_odlings
goings84911523g__o_ings
golfings13304873g_olfings
goofing123510633g_oofing_
goosing93314083g_oosing_
gorming112810833g_orming_
goslings10297553g_oslings
grooving13286713grooving_
groupings13273813groupings
incomings1445213incomings
lemmings13254733_lemmings
loadings10378383_loadings
loaming103613733_loaming_
loanings9348013_loanings
lodgings11336243_lodgings
loggings11398233_loggings
longings10408563_longings
looing73621043_loo_ing_
looking123415043_looking_
looping103615283_looping_
loosing83515963_loosing_
looting83019643_looting_
lordings10368503_lordings
losings82810623_l_osings
lowings113710073_l_owings
moorings11257713_moorings
noonings9246653_noonings
oncomings1444233oncomings
roofings12256023_roofings
rooming104117043_rooming_
shootings13266063shootings
slammings14234123slammings
spoolings12245393spoolings
toolings9248473_toolings
vrooming14287353vrooming_
zooming19269653_zooming_

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit148641926.04624585.0
3Display Results92920.0303066.7
 (SQL Overall)178691926.49927495.2
 
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.