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

101 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
lightings1427772(None) 
fightings17276501fightings
lighting132811831lighting_
lightnings15263801lightnings
sightings14256531sightings
alighting1446412alighting_
bighting15269452bighting_
blighting1635732blighting_
dighting142510842dighting_
fighting162710082fighting_
flighting1736102flighting_
highting16259722highting_
lichting14268512lichting_
ligating102212282ligating_
lightens122510002lighten_s
lightning14286022lightning_
listings93310042li_stings
plighting1635562plighting_
righting132610852righting_
sighting133110862sighting_
slighting1436372slighting_
biestings12266033biestings
biggings13327473big_gings
birthings15254623birthings
bittings11339293bi_ttings
blighties1546223blighti_es
daylightings2181013daylightings
delighting1644993delighting_
diggings12316623dig_gings
eighties12710803eighti_es
fagotings1443153fagotings
fishings15307693fish_ings
fittings12318203fi_ttings
flightiness1843893flightiness
frighting1736023frighting_
gatings95212823__gatings
infightings1952103infightings
kiltings13327083ki_ltings
knighting1844443knighting_
laggings11298403lag_gings
lashings124412253lash_ings
lastings94214423l_astings
lathings12469853lath_ings
laughings1443483laugh_ings
legating102313113legating_
leggings11316193leg_gings
lickings15298143li_ckings
lifting113313273li_fting_
ligations102111993ligations
lighten112811523lighten__
lightened1446023lightened
lightener1345693lightener
lighteners1444983lighteners
lightening15255053lightening_
lightering15246113lightering_
lighters123111393light_ers
lightish1556623lighti_sh
lightless1386073lightless
lightness13107433lightness
lightninged1751373lightninged
lights104519913light___s
lignins84010493lig_nin_s
ligroines1044993ligroines
ligroins946823ligroin_s
likings12539413li__kings
lilting83515383li_lting_
limiting1138813limiting_
linings84313073li__nings
linting83820983li_nting_
lippings13296093li_ppings
listing84020593li_sting_
lithoing1236743lithoing_
livings11408923li__vings
loathings1344213loathings
loggings11398233log_gings
lutings83311053l__utings
mightiness1645093mightiness
nigglings12213733nigglings
nighing123410063nigh_ing_
nighties121011383nighti_es
oughting1335953oughting_
pilotings1234353pilotings
pittings11349123pi_ttings
relighting1545853relighting_
riggings11327133rig_gings
righties12711573righti_es
rightisms15105623rightisms
rightists13126053rightists
siftings12236583si_ftings
sighing123311663sigh_ing_
sightlines1465753sightlines
sittings9339733si_ttings
slightingly1952263slightingly
tightens12297953tighten_s
tintings9288713ti_ntings
tithings12327693tith_ings
uplighting1743363uplighting_
weighting1744783weighting_
wiggings14316173wig_gings
wittings12328733wi_ttings
yachtings1842663yachtings

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.1731032896.0
2DLD Change Limit1486411017.33020278.4
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.54923670.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.