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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
laparoscopies196267(None) 
laparoscopes1873411laparoscop_es
laparoscope1763162laparoscop_e_
laparoscopic2062472laparoscopi_c
laparoscopist19102422laparoscopist
laparoscopists20101682laparoscopists
gastroscopies18143563gastroscopies
laparoscopy2072123laparoscop__y
laparotomies1682503laparo_tomies
aeroscopes1448014_a_eroscop_es
arthroscopies2064224arthroscopies
baroscopes1646754__baroscop_es
fluoroscopies20203074fluoroscopies
gastroscopes17104684gastroscop_es
horoscopies1856114__horoscopies
laryngoscopies2271464laryngoscopies
microscopies20167244_microscopies
radarscopes1652184radar_scop_es
uroscopies1455384___uroscopies
acarologies1446065_acaro_logies
aeroscope1347685_a_eroscop_e_
apocopes1445995_ap__o_cop_es
apospories1446185_ap__ospories
arthroscopes19125315arthroscop_es
baroscope1546575__baroscop_e_
bioscopies1645385___bioscopies
cryoscopies2054175__cryoscopies
cystoscopies2163345_cystoscopies
dichroscopes2254115dichroscop_es
electroscopes19155705electroscop_es
endoscopies1654465__endoscopies
fetoscopies1853705__fetoscopies
fluoroscopes19244405fluoroscop_es
galvanoscopes2161435galvanoscop_es
gastroscope1664255gastroscop_e_
gastroscopic1963565gastroscopi_c
gastroscopist1863085gastroscopist
gastroscopists1972135gastroscopists
gyroscopes1845075__gyroscop_es
hagioscopes1953895ha_gioscop_es
horoscopes1747645__horoscop_es
laryngoscopes2161845laryngoscop_es
leprosies1146815lep_ros___ies
lipotropies1554575lip__otropies
macroscopic1855035ma_croscopi_c
microcopies19117855_micro_copies
microscopes19119095_microscop_es
nephoscopes2054295nep_hoscop_es
otoscopies1455125___otoscopies
papyrologies2073605papyro_logies
periscopes1646355__periscop_es
polariscopes18132305polariscop_es
prosodies1249735__p_ros_odies
radarscope1552205radar_scop_e_
retinoscopies1772625retinoscopies
rhinoscopies1953815_rhinoscopies
skiascopies1951705skia__scopies
spectroscopies2262675spectroscopies
statoscopes1554825_statoscop_es
stereoscopies1763465stereoscopies

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 Filter1786911247900.406440125.6
2DLD Change Limit124790608.39014873.7
3Display Results60600.0331818.2
 (SQL Overall)178691608.82920239.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.