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

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
parachuting195251(None) 
parachutic1954292parachuti_c
parachutist1853422parachutist
parachute1644333parachut__e
parachuted1843043parachut_ed
parachutes1744153parachut_es
parachutists1952413parachutists
parching164313053par_ch__ing
racheting1537793__racheting
arching136216694_ar_ch__ing
archiving1844764_ar_chiving
brachiating1944434_brachiating
bracketing1945234_bracketing
cacheting1737154__cacheting
caracoling1545634carac_oling
caracolling1643034caracolling
chuting132910734____chuting
crocheting1844704_crocheting
fracturing1643924_fracturing
hachuring1845124__hachuring
haranguing1543114harangu_ing
marathoning1752824marathoning
marauding1344984mara__uding
marching164312194mar_ch__ing
packeting1836854p__acketing
paracrine1348724parac__rine
parading12313864para___ding
paraffining2052354paraffining
paragliding1652944paragliding
paragoning1445954para_goning
paralleling1463104paralleling
paralysing16235554para_lysing
paralyzing25185204para_lyzing
paraphrasing2052064paraphrasing
parasailing1444334parasailing
parawing14310584para___wing
parceling1438444par_c_eling
parcelling1546174par_celling
parenting12611584par__enting
pargeting1338284par__geting
pargetting1444944par_getting
parqueting2243634par_queting
parroting1239154par__roting
parting103527384par____ting
patching163212754pa_tch__ing
peaching163613644p_each__ing
perching163711634per_ch__ing
permuting1446554per__muting
persecuting1643834persecuting
pirating11314514pira___ting
placating1438514p_lac_ating
playacting1842704playac__ting
pleaching17257084pleach__ing
poaching163510834p_oach__ing
practicing1775584p_racticing
practising1586364p_ractising
prating103424454p_ra___ting
preaccusing1843164preaccusing
preaching172811164preach__ing
preacting142412534preac__ting
precasting15169834p_recasting
precenting151012154p_recenting
precluding1644174p_recluding
precuring1439424p_rec_uring
precutting1546424p_recutting
procuring1437994p_roc_uring
purchasing1893534pur_chasing
racketing1647874__racketing
ragouting1134894__ragouting
ratcheting1643784ra_tcheting
trachling1537824_trach_ling
wauchting1843474wa_uch_ting
yachting1734934__yach_ting

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.406440125.6
2DLD Change Limit148819739.18616200.6
3Display Results73730.0461587.0
 (SQL Overall)178691739.63818540.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.