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

73 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
paltrily134541(None) 
paltrier1037522paltrier
paltry114910402paltr__y
saltily10310542salt_ily
sultrily1146482sultrily
aerily93017013_a_erily
airily93014823_a_irily
alertly1046793_alertly
alterity1149843_alterity
angrily1137723_angrily
artily92814713_art_ily
balkily16266693bal_kily
balmily14216463bal_mily
cattily123210853ca_ttily
earthily1445613earthily
fattily13379463fa_ttily
faultily1474523fault_ily
filthily1743663filthily
hastily133010663hast_ily
healthily1843103healthily
joltily1746323jolt_ily
laetrile845193laetrile
nastily103011033nast_ily
nattily103610323na_ttily
palatably1644443palatably
palatally1454353palatally
palely11311923pal__ely
palfrey1533343palfr_ey
pallidly1444053pallidly
pally105727123pal___ly
palpably1745363palpably
paltering122612893paltering
paltriest1138603paltriest
pantile93918483pant_ile
pantries101817393pantries
pantry115014103pantr__y
parity114719873pa__rity
partly116315473pa__rtly
pastil85018323past_il_
pastils94416173past_ils
pastorly1345783pastorly
pastries101517423pastries
pastry114913033pastr__y
patchily1885813patchily
patly105020583pa_t__ly
patriliny1446063pa_triliny
patriot9314533pa_triot
patrol83213023pa_trol_
patrols93513513pa_trols
patronly1344883pa_tronly
pawkily1934203pa_wkily
peltries10313023peltries
peltry11288653peltr__y
petrify1536573p_etrify
pettily1238173p_ettily
pithily1567033p_ithily
plaguily1443513plaguily
polarity131310403polarity
prettily1337273prettily
psaltries1185743psaltries
psaltry12213803psaltr__y
pulpily1436103pul_pily
putridly1443493p_utridly
salutarily1353423salutarily
savorily1445043savorily
tartily103511573tart_ily
tastily103311643tast_ily
tattily10409993ta_ttily
tawdrily1542733tawdrily
warily122915093wa__rily
waterily1438783waterily
wealthily1842273wealthily
wintrily1445373wintrily

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162736.78321548.3
3Display Results73730.0302433.3
 (SQL Overall)178691736.96925640.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.