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

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

109 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
unaspirated144424(None) 
aspirated1247702__aspirated
asperated1239313__asperated
aspirate1039943__aspirate_
aspirates1139613__aspirates
exasperated2153313exasperated
inspirited1343703in_spirited
unassisted1143833unassi_sted
uncastrated1445383uncas_trated
unsaturated1244923unsaturated
unseparated1443513unseparated
unshirted13105953un_shir_ted
unsprayed1554363un_sp_rayed
asperate10312374__asperate_
asperates11312554__asperates
aspirata1054994__aspirat_a
aspiratae1143354__aspiratae
aspirator1147284__aspirator
aspired1068174__aspir__ed
auspicated1544304_auspicated
capitated14159044_ca_pitated
castigated1446324_castigated
castrated1239514_cas_trated
dispirited1445934_dispirited
evaporated1644424eva_porated
exasperate1954024exasperate_
exasperates2053784exasperates
fasciated1546134_fasci_ated
fascinated1645874_fascinated
inactivated1744554inactivated
inaugurated1353244inaugurated
inspirator1245774in_spirator
inspired1136274in_spir__ed
inspissated1451494in_spissated
instigated1247694in_stigated
lapidated1345674_la_pidated
masticated1548234_masticated
narrated9310324_na__rrated
navigated1445484_na_vigated
palpitated1544234_palpitated
passivated1644144_passivated
pirated102515614____pirated
spicated13309904___spicated
spiraled1137734___spiraled
spirited1148974___spirited
spirted103913074___spir_ted
unabated11310134una___bated
unaborted1245734una_bor_ted
unabraded1344894una__braded
unacclimated1952814unacclimated
unadmired1343864unadmir__ed
unadmitted1443024unadmi_tted
unaffiliated1952424unaffiliated
unaired82916014una__ir__ed
unalerted1047964una_ler_ted
unalienated1244014unalienated
unallocated14113324unallocated
unannotated1252274unannotated
unappeased1542624una_ppeased
unapproved1842384una_pproved
unarrayed1344184una__rrayed
unashamed1543544unas__hamed
unassayed1343494unas__sayed
unassigned1262474unassi_gned
unassimilated1662214unassimilated
unassociated1552764unassociated
unassuaged1242404unas_suaged
unassured1084354unassur__ed
unattired1045084unattir__ed
unaudited1145854unaudi__ted
unautomated1453304unautomated
unaverted1336564una_ver_ted
uncalibrated1752934uncalibrated
unciliated1348054uncili_ated
uncrated11416314un___crated
undecorated1545724undecorated
undedicated1654814undedicated
underrated12310844un_derrated
unduplicated1853684unduplicated
unexpired1943284unexpir__ed
unexpurgated2361004unexpurgated
uninspired1342574uninspir__ed
unirrigated1353284unirrigated
unliberated1444254unliberated
unmediated1445164unmedi_ated
unmedicated1744104unmedicated
unmitigated1553724unmitigated
unmotivated1753514unmotivated
unparted11310824un__par_ted
unpitted1148624un__pi_tted
unprinted1238134un__printed
unrated82621554un____rated
unreported1344074unrepor_ted
unsated83419934un_s___ated
unsaturate1054934unsaturate_
unsaturates1154604unsaturates
unscripted1544634un_scripted
unseated91317684un_s__eated
unshifted16124944un_shi_fted
unsifted12128774un_s_i_fted
unsighted1455434un_s_ighted
unsorted9312514un_s_or_ted
unspilled1245094un_spi_lled
unspotted1244934un_sp_otted
unstated91615814un_s__tated
unstinted1038564un_sti_nted
unsuited9310794un_sui__ted
unvaccinated2062394unvaccinated
uprated103213324u___p_rated

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191099.01316511.6
3Display Results1091090.0502180.0
 (SQL Overall)1786911099.48618837.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.