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

98 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
parflesh164374(None) 
parfleche1951912parfleche
parfleshes1842962parfleshes
parles86334402par_les_
paroles95025882paroles_
purfles122511842purfles_
afresh1255503_a_fresh
argles75218483_argles_
arles56735743_ar_les_
armless9369943_armless
artless73712513_artless
baffles153710683baffles_
barbless12318713barbless
barflies1338303barflies_
barkless14318023barkless
barless94317003bar_less
careless102813633careless
carles85435083car_les_
carless95118493car_less
carlish12312773car_lish
darkles124011933darkles_
dartles84014133dartles_
earless74316073ear_less
farfels13348213farfels_
farles96025783far_les_
flesh115013743___flesh
garbles104016923garbles_
garbless11388253garbless
garfish14179203garf_ish
gargles94214893gargles_
harmless1337403harmless
marbles114516653marbles_
oarfish13158613oarf_ish
oarless73913373oar_less
paddles113515643paddles_
padles95221123pa_dles_
painless10108343painless
pales75753803pa__les_
palest83926223pa__lest
palish114718273pa__lish
paneless102611763paneless
panfish15229973panf_ish
papules112411573papules_
parables121613563parables_
parades104121463parades_
paralyse1347483paralyse
parcels113712663parcels_
parches143720003parches_
parchesi15358213parchesi
parclose1247243parclose
pares77164483par__es_
pareses94718883pareses_
parfleches2042173parfleches
parges94529543par_ges_
paries84742513par_ies_
parises94827183parises_
parish115022353par__ish
parle75836163par_le__
parled94626293par_le_d
parley116718363par_le_y
parleys125212373par_leys
parole84425253parole__
paroled104217633parole_d
parolee94119643parole_e
parolees104313983parolees
parols84722613parol_s_
parrels94713493parrels_
parries93925843parries_
parses85534703par_ses_
parsley1247803parsle_y
parsleys1335083parsleys
parties93230863parties_
partlet92720363partle_t
partlets102811513partlets
parures9512693parures_
passless10247223passless
pastless102411203pastless
pathless13138043pathless
pearlash1344133pear_lash
piffles15368763piffles_
portless10310643portless
proles84627203p_roles_
purfle112511183purfle__
purfled13248733purfle_d
purfler12248733purfle_r
purflers13216963purflers
purples112712833purples_
purplest12249133purplest
purplish1554933purplish
raffles133611843raffles_
sparkles143210493sparkles_
turfless1135533turfless
waffles16329983waffles_
warbles123215563warbles_
wardless12249303wardless
warless104015103war_less
warsles103413643warsles_
wartless11279923wartless

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 Limit146162986.82621412.5
3Display Results98980.0332969.7
 (SQL Overall)178691987.26524596.1
 
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.