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 “unscented” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
unscented123751(None) 
incented112412542in_cented
scented102811882__scented
unaccented1544282unaccented
undented102313952un_dented
unrented92413922un_rented
unscanned1245132unscanned
unseated91317682uns_eated
unstinted1038562unstinted
untented92613412un_tented
absented1156613abs_ented
accented13107773_accented
ascended1246513_ascended
assented957513_assented
consented12311943cons_ented
descanted1336673descanted
descended1446283descended
discanted1339333discanted
discepted1547523discepted
dissented1199723dissented
ensconced1443343ensconced
incanted11259543in_canted
incensed11277953in_censed
incenter102212093in_center
incepted13177773in_cepted
indented101811733in_dented
inserted92413053ins_erted
insetted9249023ins_etted
inspected1445403inspected
invented122510663in_vented
precented14310693precented
resented92716963res_ented
scanted104114393__scanted
scended11329873__scended
unabetted1244993unabetted
unaccepted1743383unaccepted
unacted10312733unac__ted
unalerted1047963unalerted
unamended1344853unamended
unavenged1443663unavenged
unaverted1336563unaverted
unbelted1179333un_belted
unbended12279973un_bended
unblended13265853unblended
uncanned11289963un_canned
uncarted11312053un_carted
unceded11410563un_ce_ded
uncoated11314963un_coated
uncounted1238523uncounted
uncrated11416313un_crated
uncreated12312303uncreated
undaunted1145453undaunted
undenied102211563un_denied
undescended1643513undescended
unelected1237823unelected
unended92811823un__ended
unfelted1279403un_felted
unfenced1437733un_fenced
unheated121514553un_heated
unjointed1755583unjointed
unkenned1336183un_kenned
unlamented1344353unlamented
unletted9310313un_letted
unlicensed1343023unlicensed
unmelted1169183un_melted
unmended12299093un_mended
unmounted1245903unmounted
unopened1137023unopen_ed
unpainted1237183unpainted
unpenned1137543un_penned
unplanted1236853unplanted
unpointed1237153unpointed
unprinted1238133unprinted
unrested91914513un_rested
unsalted9510923uns_alted
unsated83419933uns__ated
unscaled111410113unsc_aled
unscarred1235673unscarred
unscathed1535313unscathed
unscreened1343373unscreened
unscrewed1554033unscrewed
unscripted1544633unscripted
unsealed91513623uns_ealed
unseamed111210663uns_eamed
unseared91113943uns_eared
unsecured1244903unsecured
unseeded1038253uns_eeded
unsegmented1552443unsegmented
unseized1838443uns_eized
unselected1344973unselected
unsent63820963uns_ent__
unserved12410233uns_erved
unsettled1055213uns_ettled
unsewed112911023uns_e_wed
unsexed152410253uns_e_xed
unsheathed17174133unsheathed
unshelled1336563unshelled
unshifted16124943unshifted
unshirted13105953unshirted
unsifted12128773uns_ifted
unsighted1455433unsighted
unsigned1037563unsign_ed
unsorted9312513uns_orted
unsounded1135543unsounded
unspent92610893unspent__
unspotted1244933unspotted
unstated91615813uns_tated
unsteeled1045753unsteeled
unstemmed1443303unstemmed
unstepped1444213unstepped
unstoned9311043unston_ed
unsuited9310793uns_uited
untainted1038423untainted
untalented1144843untalented
untended102611153un_tended
untested92612413un_tested
untreated10312903untreated
unvested122210223un_vested
unwanted12249603un_wanted
unwetted1238123un_wetted
unwonted12248643un_wonted

Search took 7 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 Filter1786911486410.406440125.6
2DLD Change Limit1486411216.23323847.4
3Display Results1211210.0631920.6
 (SQL Overall)1786911216.70226662.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.