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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
parawings153583(None) 
parawing14310581parawing_
drawings13386282_drawings
parading12313862parading_
parangs104314382para__ngs
parasangs1246042parasangs
pargings123410172par_gings
parings104219222par__ings
parkings153610692par_kings
partings113513742par_tings
phrasings1544332phrasings
arcadings1354393_arcadings
archings14499863_archings
armings103811503_ar_mings
bracings13369293_bracings
brewings14296693_brewings
carabines13311483carabines
carabins12312363carabin_s
cardings123812643car_dings
carlings114015863car_lings
carpings133812393car_pings
carvings143810213car_vings
cravings14428223_cravings
darings93713653dar__ings
darklings1533983darklings
darlings103710383dar_lings
darnings10378553dar_nings
drawing123812053_drawing_
earings84517713ear__ings
earnings9419333ear_nings
earrings9299633ear_rings
earwigs11104413ear_wi_gs
farmings14298223far_mings
farthings1635233farthings
forewings1645113forewings
framings14338133_framings
frayings15325993_frayings
garaging1139043garaging_
gaywings1633193ga_ywings
gnawings13263773_gnawings
gratings103910763_gratings
grazings19337263_grazings
harpings14379773har_pings
kartings13418523kar_tings
kayakings1642683kayakings
lacewings1543303lacewings
lapwings14274973la_pwings
lawings113611473__lawings
marblings14225543marblings
markings153410243mar_kings
marlings113713503mar_lings
packagings2042543packagings
packings174310063pa_ckings
paddings13297013pa_ddings
paddlings14224363paddlings
pagings114411063p__agings
paintings12327103paintings
pairings11398313pa_irings
paladins11911003paladin_s
palatines11313053palatines
palings103915823p__alings
panelings12107463panelings
papains11312373papa_in_s
paradigm1446243paradi_gm
paradigms1544653paradigms
paradises122513213paradises
paraffines1844333paraffines
paraffins1744653paraffin_s
paragons11311513paragon_s
parakites1549553parakites
paraments13511563paraments
parang93715513para__ng_
parasang1147333parasang_
parasites11313163parasites
paravanes1448313paravanes
parbaking1877203parbaking_
parching164313053parching_
parentings1355633parentings
pargetings1443713pargetings
parging113318603par_ging_
paring94236493par__ing_
parking143423043par_king_
parlaying1537303parlaying_
parling103823763par_ling_
paroling113316213paroling_
parring103222063par_ring_
parrying14168133parrying_
parsing103819553par_sing_
partaking1698673partaking_
parting103527383par_ting_
partying14168893partying_
passings11409873pa_ssings
pavings134011633p__avings
pawing124519553p__awing_
periwigs1444193periwi_gs
pharmings17254723phar_mings
phrasing1438013phrasing_
phreakings2043193phreakings
pirating11314513pirating_
platings113611363p_latings
pleadings13285543pleadings
pralines102217733p_ralines
prangs94816233p_ra__ngs
prating103424453p_rating_
prawning1446963p_rawning_
prawns11509023p_raw_n_s
praying133717323p_raying_
primings13338143p_rimings
pshawing1733523pshawing_
purflings1554103purflings
purgings12347293pur_gings
purlings113910283pur_lings
racings105015133__racings
ratings84217413__ratings
ravings114614503__ravings
rawins95617623__rawin_s
rowings113710363__rowings
scrapings14255173scrapings
sparlings12257153spar_lings
strawing122411623strawing_
thrawing1535963thrawing_
tracings112910413_tracings
warnings12358453war_nings
waxwings2232953wa_xwings

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411247.39320105.6
3Display Results1241240.0602066.7
 (SQL Overall)1786911247.87322696.7
 
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.