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

56 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
pastalike154672(None) 
mastlike1437862mast_like
pashalik1744182pashalik_
pashaliks1843512pashaliks
antlike11312073_ant_like
asslike1137373_as_slike
astatine8313533_astatine
basinlike1553383basinlike
batlike133311883ba_t_like
catlike132712933ca_t_like
dustlike1335363dust_like
earthlike1644623earthlike
fatlike142911193fa_t_like
gatelike1337933ga_telike
hatlike143311713ha_t_like
lavalike1536283la_valike
masklike1335593mas_klike
nasalise848863nas_alise
nasalize1748183nas_alize
nestlike1236083nest_like
oatlike113412403oa_t_like
palatalize2144873palatalize
palmlike1656043pa_lmlike
palsylike1842703palsylike
pantalone1146833pantalone
parklike1337493pa_rklike
partake1339643parta__ke
pashalic1546183pashali_c
pashalics1644273pashalics
pastelist1149623pastelist
pastie85525523past__i_e
pastille1038943pastil_le
pastime114611973past__ime
pealike131211273p__ealike
petaline10314883p_etaline
petallike1554633p_etallike
pizzalike2341803pizzalike
plantlike1544943plant_like
platelike1546143platelike
poetlike1436733poet_like
potlike13910123p_ot_like
puslike1347563pus__like
pusslike1434033pus_slike
puttylike1841813puttylike
rashlike1535793ras_hlike
ratlike113912353ra_t_like
saltlike1237253salt_like
starlike1238813__starlike
tantalise91210823tantalise
tantalite91010863tantalite
tantalize181010573tantalize
vaselike1536993vas_elike
vestlike1535393vest_like
wartlike1537043wart_like
wasplike1734893was_plike
yeastlike1672993yeast_like

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 Filter1786911486410.436409841.7
2DLD Change Limit148641568.20318120.3
3Display Results56560.063888.9
 (SQL Overall)178691568.70220534.5
 
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.