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

41 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
playwrighting266104(None) 
playwrightings277681playwrightings
playwriting2052022playwri__ting
playwright2252113playwright___
playwrights2351693playwright__s
playwritings2151283playwri__tings
affrighting2252014__affrighting
copyrighting2451634copy_righting
daylighting2072064_day_lighting
plighting1635564pl____ighting
alighting1446415__a__lighting
backlighting2552475_backlighting
blighting1635735bl____ighting
claughting1742485cla___ughting
daylightings2181015_day_lightings
flighting1736105fl____ighting
floodlighting226925floodlighting
frighting1736025____frighting
jacklighting3051725_jacklighting
lariating10311785_la__ri_ating
lighting132811835_l____ighting
limelighting1961435_limelighting
overweighting2453135overweighting
pargeting1338285p_a__r_geting
patriating13510205p_a_tri_ating
plaiting113113515pla___i__ting
planishing1645325pla__nish_ing
playacting1842705play___acting
playgoing1663565play___g_oing
plaything1843855play___th_ing
preflighting2252655p_reflighting
preweighing2142335p_reweigh_ing
prewriting1647245p_rewri__ting
prizefighting3291145prizefighting
righting132610855_____righting
skywriting2141935_skywri__ting
slighting1436375sl____ighting
unweighting1952305__unweighting
uplighting1743365upl____ighting
uprighting1743465___uprighting
weighting1744785____weighting

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.390458182.1
2DLD Change Limit124790418.48314710.6
3Display Results41410.0331242.4
 (SQL Overall)178691418.90620064.1
 
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.