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

92 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
parasang114733(None) 
parasangs1246031parasangs
parading12313862parading
parang93715512par__ang
parasail1049232parasail
paravane1348102paravane
parawing14310582parawing
parsing103819552par_sing
phrasing1438012phrasing
abasing10610673_abasing
arising83619973_arising
caragana1146283caragana
caravan1239233caravan_
caravans1338623caravans
erasing8317963_erasing
garaging1139043garaging
harassing1346983harassing
paesan85114093pa_esan_
paesani9348683pa_esani
paesano9338793pa_esano
paesans93312693pa_esans
paisan84417073pa_isan_
paisana94010223pa_isana
paisano9429513pa_isano
paisans93614753pa_isans
papayan1445303papayan_
paragon10311023paragon_
paragons11311503paragons
paralysing16235553paralysing
parament12415393parament
parangs104314373par__angs
paras76143043paras___
parasailing1444333parasailing
parasails1147583parasails
parashah1646453parashah
parashahs1744743parashahs
parashot13410143parashot
parasite10314843parasite
parasol939553paras_ol
parasols1039263parasols
paravanes1448303paravanes
parawings1535823parawings
parazoan1946553parazoan_
parazoans2045603parazoans
parbaking1877203parbaking
parching164313053parching
parging113318603par_ging
parian83223963par_ian_
parians93519733par_ians
paring94236493par__ing
parking143423043par_king
parkland1545373parkland
parlaying1537303parlaying
parling103823763par_ling
parmesan1244753parmesan_
parmesans1344103parmesans
paroling113316213paroling
parring103222063par_ring
parrying14168133parrying
parson83817903par_son_
parsons93516873par_sons
partaking1698673partaking
partan83820563par_tan_
partans94418283par_tans
parting103527383par_ting
partisan1058423partisan_
partisans1167483partisans
partying14168893partying
passant9813943pa_ssant
passing104318423pa_ssing
pausing103912813pa_using
peasant9314923p_easant
perusing11811063perusing
phasing133211673p_hasing
pheasant1347083pheasant
phrasal1246163phrasa_l
phrasings1544333phrasings
pirating11314513pirating
pleasant1048323pleasant
pleasing112611593pleasing
praising113214563praising
prang84820323p_r__ang
prating103424453p_rating
praying133717323p_raying
presong1039843p_resong
prising103321453p_rising
probang12278383p_robang
prosing103319383p_rosing
pursing103715553pur_sing
rasing74330833__rasing
saladang1043843saladang
saraband1146193saraband

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 Filter1786911461620.420425454.8
2DLD Change Limit146162927.84618628.9
3Display Results92920.0462000.0
 (SQL Overall)178691928.31221498.0
 
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.