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

112 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
gloamings1325409(None) 
gloaming12268011gloaming_
gloomings13283971gloomings
coamings13349292_coamings
gamings114610912g__amings
glazings19325752gl_azings
gleaming12277932gleaming_
gleanings11244642gleanings
gloating102611462gloating_
glomming14275922glomming_
glooming12358012glooming_
loadings10378382_loadings
loaming103613732_loaming_
loanings9348012_loanings
aliasings1043653aliasings
bladings12337753bl_adings
blaming123515693bl_aming_
bloating113512813bloating_
bloggings14264263bloggings
bloodings13245273bloodings
blooming13299433blooming_
boatings113710113_boatings
clearings12286063clearings
cloaking15299713cloaking_
clonings11307433clo_nings
closings11277673clo_sings
clothings15264433clothings
coaming123818323_coaming_
coatings113811843_coatings
comings124013533_co_mings
flamines13311643fl_amines
flaming134216443fl_aming_
flamingo14274143fl_amingo
flamingos15293093fl_amingos
floating123111883floating_
flockings19314343flockings
floggings15314123floggings
floorings13245093floorings
foaming133612993_foaming_
framings14338133_framings
gallamines1345493gallamines
gamines103618463g__amines
gaming104622043g__aming_
gamins94420053g__amin_s
gatings95212823g__atings
gearings10359503g_earings
ghostings1433483ghostings
glaring93714883gl_aring_
glazing183611003gl_azing_
gleaning10269323gleaning_
gleyings13283653gl_eyings
gliadines1144773gliadines
gliadins1035193gliadin_s
gliming113310133gl_iming_
gloams95210663gloam___s
gloatingly1543563gloatingly
globing113210003glo_bing_
globins10278953glo_bin_s
glonoins955843glonoin_s
gloominess1343833gloominess
glopping14307753glopping_
glorying1335543glorying_
glossinas10214143glossinas
glossing10278883glossing_
glouting10379693glouting_
gloving12308443glo_ving_
glowing123211793glo_wing_
glozing18338893glo_zing_
glutamines1343503glutamines
gnawings13263773g_nawings
goading103112853g_oading_
goaling93515333g_oaling_
godlings11367493g_odlings
goings84911523g_o__ings
golfings13304873g_olfings
gorming112810833g_orming_
goslings10297553g_oslings
gratings103910763g_ratings
grazings19337263g_razings
groaning102410283groaning_
grooming12309513grooming_
groupings13273813groupings
lacings105013653_l_acings
ladings93814133_l_adings
lakings124713513_l_akings
laminas93615873_l_aminas
laming94528363_l_aming_
lawings113611473_l_awings
leadings103511243_leadings
leanings94010183_leanings
leasings9379843_leasings
leavings12407493_leavings
lemmings13254733_lemmings
loading94114613_loading_
loafing11319793_loafing_
loaminess1137493_loaminess
loaning83614833_loaning_
loathings1344213_loathings
lodgings11336243_lodgings
loggings11398233_loggings
longings10408563_longings
looming102814853_looming_
lordings10368503_lordings
losings82810623_lo_sings
lowings113710073_lo_wings
platings113611363pl_atings
pleadings13285543pleadings
roaming103215793_roaming_
roarings9248293_roarings
slammings14234123slammings
slatings94011723sl_atings
soarings93210393_soarings

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411127.29620372.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.76523012.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.