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

81 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
paschals156647(None) 
pascals11610011pasc_als
paschal14157241paschal_
pachas135017142pa_cha_s
pascal10812372pasc_al_
pashas115117062pas_ha_s
rascals959662rasc_als
apicals1159923apic_als
archils12510533_archils
ashcans1235183_ashcans
asocials1075683_asocials
asphalt1248083_asphalt
asphalts1344183_asphalts
astrals75515243_astrals
barchans1588683barchans
bashaws15347713bas_haws
canchas143212403cancha_s
cashaws15398573cas_haws
casuals91410523cas_uals
catchall1546233catchall
catchalls1645493catchalls
dachas124113253da_cha_s
datchas1347423datcha_s
eschars1237183_eschars
facials123310743fa_cials
fascial1258303fascial_
fascias1258413fascia_s
faucals12326563fauc_als
fiscals1238003fisc_als
gasohols1243723gasohols
hatchels16368673hatchels
jacals1539873ja_c_als
jackals2036893ja_ckals
kashas133311903kas_ha_s
lascars979013lasc_ars
marshals1337783marshals
mescals112911563mesc_als
nachas114914193na_cha_s
narwhals1443613narwhals
nasals63312463nas__als
nuchals12216933_nuchals
pacas96029403pa_c_a_s
pacha126518063pa_cha__
pachalic1757273pa_chalic
pachalics1844983pa_chalics
padshahs17113153padshahs
pakehas1635313pakeha_s
palatals1037773palatals
panchax2134983pancha_x
panchaxes2344453panchaxes
panochas1545653panocha_s
parcels113712663parc_els
parches143720003parch_es
parrals94414573pa_rrals
partials101911963partials
pasha105417183pas_ha__
pashalic1546183pas_halic
pashalics1644273pas_halics
pashalik1744183pas_halik
pashaliks1843513pas_haliks
pashes115828393pas_h_es
pasquils1943123pasquils
passels93913023pas_sels
pastas85422873pas_ta_s
pastels95215183pas_tels
pastils94416173pas_tils
pastorals1147953pastorals
patchable1845633patchable
patchers153413303patchers
patches143320383patch_es
patchily1885813patchily
pechans14810503p_echans
postals93716373pos_tals
pshaws14435703p_s_haws
rascal8511123rasc_al_
sacrals93311793sa_crals
sashays1336333sas_hays
satchels13328163satchels
schavs1436493__schavs
schuls11299853__schuls
vassals1057953vas_sals

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.406440125.6
2DLD Change Limit146162817.29620033.2
3Display Results81810.0332454.5
 (SQL Overall)178691817.73523101.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.