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

48 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
unprecedented196119(None) 
unprecedentedly2415772unprecedentedly
precedence1746114__precedence_
precedences1845514__precedences
precedent1448874__precedent__
precedents1545724__precedent_s
precented14310694__prec__ented
recemented1546164___recemented
unfrequented2551844unfre_quented
unpremeditated2061334unpremeditated
unrepresented1661694un_represented
antecedence1652915an_tecedence_
antecedences1752515an_tecedences
antecedent1354375an_tecedent__
antecedently1862025an_tecedently
antecedents1453345an_tecedent_s
copresented1653825copr__esented
preceded1438295__preced___ed
precedencies1953725__precedencies
precedency2053695__preceden_cy
prededucted1852335__prededucted
preedited1337635__pre_ed_ited
preelected1545785__pre_elected
preerected1545575__pre_erected
preselected1643965__preselected
presented12311635__pr__esented
prevented1539005__pr__evented
represented1444115repr__esented
unaccented1544285un__ac_cented
unbracketed2051535unbrac_ke_ted
uncredited1445005uncr__ed_ited
undecadent1453575un_decadent__
undented102313955un_____dented
undercounted1653255underc_ounted
undocumented1851805un_documented
unfermented1743865un_fe_rmented
unornamented1551745unor_namented
unperceived1952975unperc__eived
unprejudiced2561015unprejud_iced
unprinted1238135unpr____inted
unprocessed1652845unproc__essed
unprotected1652755unpr__otected
unrecovered1752375un_recove_red
unredeemed1442355un_r__edeemed
unrented92413925un_r____ented
unscented1237515un__sc__ented
unsegmented1552445un_se_gmented
unsweetened1551195unswe_eten_ed

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.423422437.4
2DLD Change Limit124790488.51614653.6
3Display Results48480.0301600.0
 (SQL Overall)178691488.96919923.2
 
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.