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

63 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
infighting184441(None) 
infightings1952101infightings
fighting162710082__fighting
gunfighting2051772gunfighting
knighting1844442kn_ighting
refighting1845202refighting
unsighting1584442unsighting
affrighting2252013affrighting
alighting1446413_alighting
bedighting1844173bedighting
bighting15269453__bighting
blighting1635733_blighting
delighting1644993delighting
dighting142510843__dighting
dogfighting2151503dogfighting
fightings17276503__fightings
flighting1736103_flighting
freighting1844543freighting
frighting1736023_frighting
highting16259723__highting
inciting11312533inci__ting
indagating1345263indagating
indicating1449693indicating
indicting1339613indi_cting
indigotin1144193indigotin_
indigotins1243843indigotins
inditing10312113indi__ting
infecting15109673inf_ecting
infesting13109513inf_esting
infight1437453infight___
infighter1644273infight_er
infighters1743323infighters
infights1545573infight__s
infirming1545163infi_rming
infixing1936103infi__xing
inflating13310443inf_lating
inflecting1646313inflecting
inflicting1645723inflicting
infracting1647353infracting
ingoting1039863in__goting
inhibiting1645113inhibiting
insisting1038823insi_sting
instigating1347153instigating
intimating13410823intimating
inveighing1842733inveigh_ing
inviting1239733invi__ting
irrigating1245953irrigating
lighting132811833__lighting
mislighting1843413mislighting
neighing1355523_neigh_ing
nighing123410063_n_igh_ing
outfighting1943313outfighting
plighting1635563_plighting
relighting1545853relighting
resighting1546073resighting
righting132610853__righting
sighting133110863__sighting
slighting1436373_slighting
unfitting1336423unfi_tting
unweighting1952303unweighting
uplighting1743363uplighting
uprighting1743463uprighting
weighting1744783_weighting

Search took 6 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 Filter1786911406030.423422437.4
2DLD Change Limit140603635.51325503.9
3Display Results63630.0331909.1
 (SQL Overall)178691635.96929936.5
 
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.