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

93 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
fightings1727650(None) 
fighting162710081fighting_
lightings14277721lightings
sightings14256531sightings
bighting15269452bighting_
dighting142510842dighting_
fagotings1443152fagotings
fishings15307692fish_ings
fittings12318202fi_ttings
flighting1736102flighting_
frighting1736022frighting_
highting16259722highting_
infightings1952102infightings
lighting132811832lighting_
lightnings15263802lightnings
righting132610852righting_
sighting133110862sighting_
alighting1446413alighting_
biestings12266033biestings
biggings13327473big_gings
birthings15254623birthings
bittings11339293bi_ttings
blighting1635733blighting_
diggings12316623dig_gings
eighties12710803eighti_es
faggotings1641633faggotings
fagoting1336283fagoting_
farthings1635233farthings
fastings124011943f_astings
feltings12317903f_eltings
fidgeting1544523fidgeting_
figging133313563fig_ging_
fighters15269403fight_ers
fights133816553fight___s
figulines1345043figulines
figurines1344503figurines
figuring1336283figuring_
fileting1239303fileting_
filings115213073fi__lings
fillings122910503fi_llings
findings13328443fi_ndings
fingerings1545073fingerings
finings114311773fi__nings
firings114112333fi__rings
firstlings1442523firstlings
fishgigs1642093fishgi_gs
fishing143913863fish_ing_
fishlines15246843fishlines
fisting113818123fi_sting_
fitting113516563fi_tting_
fixating1936183fixating_
fixings18347443fi__xings
flightiness1843893flightiness
flutings12357373f_lutings
flytings15304793f_lytings
footings12248833f_ootings
freighting1844543freighting_
frightens1655393frighten_s
frostings1335733frostings
gatings95212823__gatings
infighting1844413infighting_
kiltings13327083ki_ltings
knighting1844443knighting_
lichting14268513lichting_
ligating102212283ligating_
lightens122510003lighten_s
lightning14286023lightning_
listings93310043li_stings
mightiness1645093mightiness
nigglings12213733nigglings
nighing123410063nigh_ing_
nighties121011383nighti_es
oughting1335953oughting_
pilotings1234353pilotings
pittings11349123pi_ttings
plighting1635563plighting_
refighting1845203refighting_
riggings11327133rig_gings
righties12711573righti_es
rightisms15105623rightisms
rightists13126053rightists
siftings12236583si_ftings
sighing123311663sigh_ing_
sightlines1465753sightlines
sittings9339733si_ttings
slighting1436373slighting_
tightens12297953tighten_s
tintings9288713ti_ntings
tithings12327693tith_ings
weighting1744783weighting_
wiggings14316173wig_gings
wittings12328733wi_ttings
yachtings1842663yachtings

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.436409841.7
2DLD Change Limit148641935.87625296.3
3Display Results93930.0462021.7
 (SQL Overall)178691936.35828104.9
 
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.