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

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
districting155900(None) 
distracting1569251distracting
abstricting1654502abstricting
astricting1357832_astricting
destructing1546112destructing
distributing1654742distributing
distrusting1386492distrusting
redistricting1753782redistricting
restricting1449302restricting
abstracting1645183abstracting
constricting1747023constricting
detracting1438713d_etracting
diffracting2143343diffracting
directing1338823di__recting
disfrocking2252963disfrocking
disgracing1586743disgrac_ing
disheriting1646453disheri_ting
disjecting2177243dis_jecting
disjointing2045293disjointing
disorienting14155653disorienting
dispiriting1545943dispiriting
disprizing2347923dispri_zing
disquieting2244303disquieting
disrating11714553dis_r_ating
disrooting1247743dis_rooting
disrupting1446343dis_rupting
dissecting14139473dis_secting
distaining1248903distai_ning
distancing1447083distanc_ing
distasting1248023dist_asting
distilling1247793dist_illing
distorting1239583dist_orting
distractingly2053253distractingly
distraction1449113distraction
distractions1548753distractions
distractive1746773distractive
distraining1346983distraining
distressing1385973distressing
district11413873district___
districted1448223district_ed
districts1248933district__s
disuniting1247403disuni_ting
divaricating1953593divaricating
instructing1446293instructing
mispricing1746713mispric_ing
misprinting1646823misprinting
mistracing1569603mistrac_ing
mistreating1449283mistreating
mistrusting1465923mistrusting
mistrysting1774313mistrysting
miswriting1646843miswri_ting
obstructing1644573obstructing
striating10914193__striating

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 Filter1786911216330.593301333.9
2DLD Change Limit121633537.15616997.3
3Display Results53530.0134076.9
 (SQL Overall)178691537.76223021.3
 
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.