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

105 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
unshirted1310595(None) 
unshifted16124941unshifted
uncharted1538082uncharted
unhired112512152un_hir_ed
unshared121510702unshar_ed
unshipped1743862unshipped
unsifted12128772uns_ifted
unsorted9312512uns_orted
unstinted1038562unstinted
unsuited9310792unsui_ted
upshifted1882202upshifted
enshrined1344523enshrined
inserted92413053ins_erted
inshrined1344423inshrined
insisted998673ins_isted
inspired1136273inspir_ed
inspirited1343703inspirited
redshirted1592693redshirted
shifted14359983__shifted
shirked153710463__shirked
shirred113710503__shirred
shitted114212053__shitted
shorted113614403__shorted
skirted12388613__skirted
spirted103913073__spirted
unaborted1245733unaborted
unaired82916013un_air_ed
unalerted1047963unalerted
unaspirated1444243unaspirated
unassisted1143833unassisted
unaverted1336563unaverted
unbitted1138213un_bitted
uncarted11312053un_carted
unchaired1536203unchair_ed
uncharged1636613uncharged
uncharred1536103uncharred
unchilled1545563unchilled
undershirted1753473undershirted
unedited10249833unedi_ted
unfired112212453un_fir_ed
unfitted1238163un_fitted
ungifted13116833un_gifted
ungirded1136083un_girded
unhaired12238763unhair_ed
unharmed1438093un_harmed
unhatted1238183un_hatted
unheated121514553un_heated
unhinged13257473un_hinged
unhorsed1238833un_horsed
united74421543un__i_ted
unjointed1755583unjointed
unknitted1443703unknitted
unlisted9311153un_listed
unmerited1239643unmerited
unmitred1136843un_mitred
unpainted1237183unpainted
unpaired11208943unpair_ed
unparted11310823un_parted
unpitted1148623un_pitted
unpointed1237153unpointed
unprinted1238133unprinted
unsalted9510923uns_alted
unsated83419933uns__ated
unscarred1235673unscarred
unscented1237513unscented
unscripted1544633unscripted
unseared91113943unsear_ed
unseated91317683uns_eated
unseized1838443unsei_zed
unserved12410233uns_erved
unshaded13149263unsh_aded
unshamed14148053unsh_amed
unshaped14148443unsh_aped
unshaved15157733unsh_aved
unsheathed17174133unsheathed
unshed10313773unsh___ed
unshelled1336563unshelled
unshift1387413unshift__
unshifts1444033unshift_s
unsighted1455433unsighted
unsigned1037563uns_igned
unsized172510543uns_i_zed
unskilled1444603unskilled
unsliced1138093unsli_ced
unsnarled1035743unsnarled
unsoiled92412083unsoi_led
unsourced1244833unsourced
unsoured9310063unsour_ed
unsphered1556103unspher_ed
unspilled1245093unspilled
unspotted1244933unspotted
unstarred1036363unstarred
unstated91615813uns_tated
unstriped1246303unstriped
untainted1038423untainted
untilted9610893un_tilted
untired82316383un_tir_ed
untwisted1344863untwisted
ununited938683ununi_ted
unwhipped2042363unwhipped
unwhite1336813unwhi_te_
unwitted1237543un_witted
upstarted1244213upstarted
upstirred1241823upstirred
ushered1139153u_sher_ed

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411057.25020502.2
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.73623098.6
 
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.