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 “bullfightings” with Change Limit: [1] [2] [3] [4] [5] [6]

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

53 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
bullfightings23695(None) 
bullfighting2251511bullfighting_
bullfighters216993bullfight_ers
bullfights1951973bullfight___s
blighting1635734b__l_ighting_
bullbaitings1751054bull_baitings
bulldoggings186974bulldog_gings
bullfight1842934bullfight____
bullfighter2051294bullfight__er
cockfightings296864cockfightings
daylightings2181014dayl_ightings
fightings17276504____fightings
gunfighting2051774gu_nfighting_
infightings1952104__infightings
lightings14277724___l_ightings
outfighting1943314ou_tfighting_
uplighting1743364_upl_ighting_
alighting1446415__al_ighting_
backlighting2552475backlighting_
bedighting1844175b__edighting_
beknighting2251885b_eknighting_
bighting15269455b____ighting_
blighties1546225b__l_ighti_es
bonefishings2151365bonefish_ings
bullbaiting1651945bull_baiting_
bulldogging1751685bulldog_ging_
bulleting1236645bull___eting_
bulletins1146335bull___etin_s
bullrings12314625bull____rings
bullshitting1851205bullshitting_
burnishings1751865bu_rnish_ings
cockfighting2851345cockfighting_
colligating1545715coll_igating_
daylighting2072065dayl_ighting_
delighting1644995_del_ighting_
dogfighting2151505_dogfighting_
fighting162710085____fighting_
flighting1736105__fl_ighting_
infighting1844415__infighting_
lighting132811835___l_ighting_
lightnings15263805___l_ightnings
mislighting1843415misl_ighting_
plighting1635565__pl_ighting_
preflighting2252655preflighting_
prizefightings3312815prizefightings
publishings1951845publ_ish_ings
refighting1845205__refighting_
relighting1545855_rel_ighting_
sightings14256535____sightings
slighting1436375__sl_ighting_
unsighting1584445_u_nsighting_
unweighting1952305_unweighting_
uprighting1743465_u_prighting_

Search took 9 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 Filter1786911247900.406440125.6
2DLD Change Limit124790537.95315690.9
3Display Results53530.0331606.1
 (SQL Overall)178691538.39221293.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.