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

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

68 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
dyings1147813(None) 
dings76331401d_ings
doings84913181doings
dyeings12374641dyeings
dying105316031dying_
lyings10488501lyings
agings86312672agings
ayins85321612ayin_s
beings94613032beings
boings96416872boings
brings94618432brings
clings95716212clings
dangs75623202d_angs
darings93713652darings
deigns8389982deigns
digs66036052d_i_gs
dines66449152d_ines
ding66940952d_ing_
dinge75627302d_inge
dinges83825422d_inges
dingo74720792d_ingo
dingus83611842d_ingus
dingy105721262d_ingy
dinks105927952d_inks
dinos65428062d_inos
dins56652042d_in_s
dints67431312d_ints
djinns1443132djinns
djins1368452djin_s
doing74923582doing_
dongs76525812d_ongs
dopings11408782dopings
drinks116810712drinks
drying113411602drying_
dungs75821972d_ungs
dwines105013102dwines
dyeing11428212dyeing_
dyking15458012dyking_
dynes95917582dy_nes
edgings10256242edgings
eying96117922eying_
flings106715282flings
flyings14496062flyings
goings84911522goings
hayings14379392hayings
hying126514742hying_
icings9428452icings
kings105825562_kings
lings67135772_lings
lying95717452lying_
mayings134410512mayings
pings85830882_pings
pyins105815862pyin_s
rings65029172_rings
sayings113610832sayings
sings65532702_sings
slings74618012slings
stings76220182stings
swings104714452swings
things104914302things
tings65329202_tings
tying96019842tying_
vying125111812vying_
wings95727242_wings
wrings104012972wrings
yangs95618692_yangs
yins75335122_yin_s
zings154620892_zings

Search took 4 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 Filter178691825510.626285448.9
2DLD Change Limit82551682.45033694.3
3Display Results68680.0332060.6
 (SQL Overall)178691683.10957475.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.