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

113 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
lustrings1024555(None) 
lustring9269721lustring_
dustings10419032dust_ings
hustings12378682hust_ings
lastings94214422last_ings
listings93310042list_ings
lustering102711202lustering_
lusting83619322lust_ing_
lutestrings1252112lutestrings
lutings83311052lu_t_ings
outrings92811052ou_trings
restrings10159292restrings
strings84617132__strings
unstrings1046012unstrings
astringe938223_astringe
astringes1038333_astringes
bastings114214693bast_ings
blastings12347913blast_ings
blustering13106183blustering_
bowstrings16173223bowstrings
bullrings12314623bullrings
buntings11348773bunt_ings
bushings14348793bus_hings
busings103711223bus__ings
bussings11386663bus_sings
busting104221793bust_ing_
bustlines11207353bustlines
bustling112110063bustling_
castings113614053cast_ings
centrings12227603centrings
clustering13116813clustering_
cuttings11277613cu_ttings
ductings12346673duct_ings
dustbins1144593dustbin_s
dusting93618993dust_ing_
dustrags1044943dustr_ags
eastings93412953east_ings
estrins7315853_estrin_s
eyestrings1462773eyestrings
fastings124011943fast_ings
flustering14105933flustering_
flutings12357373flu_t_ings
furrings12317143fu_rrings
gastrins9310123gastrin_s
gusting93917163gust_ing_
gutterings12224913gutterings
hamstrings1643013hamstrings
huntings12328053hunt_ings
huskings16276043hus_kings
hustling12228793hustling_
jestings16368023jest_ings
justing153615163just_ing_
justling16207253justling_
lashings124412253las_hings
lasting84725243last_ing_
lathings12469853l_athings
latrines8515003l_atrines
layerings13235683layerings
letterings11226003letterings
listing84020593list_ing_
loathings1344213loathings
lobsterings1442893lobsterings
losings82810623los__ings
lumberings15103783lumberings
lunting83817743lunt_ing_
luring73820753lu__ring_
lushing114316113lus_hing_
lustiness92010453lust_iness
lustrates939463lustrates
lustrating1147783lustrating_
lustres73013233lustr__es
lustrous877803lustr_ous
lustrums1044663lustr_ums
luteins7310103lu_tein_s
lutestring1143473lutestring_
luting75221753lu_t_ing_
muntings11289813munt_ings
musings10389543mus__ings
mustangs11255973must_angs
mustering122212333mustering_
musting103221073must_ing_
nestlings1074313nestlings
nuttings9276783nu_ttings
oestrins8312673oestrin_s
ousting84021353oust_ing_
outings84014753ou_t_ings
outrigs82811263ou_tri_gs
outring84021023ou_tring_
outsings93410333ou_tsings
outsprings1343953outsprings
outswings1354353outswings
oysterings1443903oysterings
plasterings1444743plasterings
postings112912303post_ings
resprings12156253resprings
restring91518783restring_
rushings12387843rus_hings
rusting83821263rust_ing_
rustling9249983rustling_
sorings83817253__sorings
springs104415923__springs
stings76220183__st_ings
string75327563__string_
stringy114111073__stringy
subrings11229883su_brings
suitings9288953suit_ings
sustains838553sustain_s
tuftings12264323tuft_ings
turtlings10184873turtlings
unstring9312093unstring_
upsprings1442703upsprings
vestings12359143vest_ings
westings12429803west_ings

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.1701051123.5
2DLD Change Limit1486411137.14320809.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.35924282.0
 
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.