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

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

68 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
parasitologists1862801parasitologists_
parasitologist1763252parasitologist__
parasitologies1782363parasitologi_es_
parasitologic1862254parasitologi___c
parasitological2062774parasitologi_cal
phraseologists2053574phras_eologists_
cardiologists1765145car_di_ologists_
malariologists1773355malari_ologists_
narratologists1553215nar_ratologists_
paleontologists1884525paleontologists_
parasitology1862535parasitolog____y
phraseologist1954195phras_eologist__
physiologists22156015p_hysi_ologists_
planetologists1763625p_lanetologists_
primatologists19184355p_rimatologists_
proctologists1856815p_r_octologists_
radiologists1497365__radi_ologists_
teratologists1496595tera__tologists_
archaeologists20122816_archaeologists_
audiologists1445616_a_udi_ologists_
cardiologist1656616car_di_ologist__
criminologists1952976_criminologists_
cryptologists2155236_cr_yptologists_
dermatologists18134926der_matologists_
diabetologists18122816_diabetologists_
gerontologists1654856ger_ontologists_
glaciologists1753946_glaci_ologists_
graphologists20123836_gra_phologists_
hematologists19217056hema__tologists_
herpetologists2083636her_petologists_
histologists1646296__his_tologists_
iridologists1444686_ir__idologists_
malacologists1854406mala__cologists_
malariologist1693926malari_ologist__
martyrologists2062896mar_tyrologists_
musicologists1853546__musicologists_
narratologist1453836nar_ratologist__
nematologists16166606nema__tologists_
ornithologists1852596_or_nithologists_
paleobiologists20115736paleobiologists_
paleoecologists20124176paleoecologists_
paleontologist1765146paleontologist__
paleozoologists2763856paleozoologists_
palynologists1954996p__alynologists_
papyrologists2154086p__apyrologists_
paralogisms1654116para____logisms_
parasitises1377376parasit____ises_
parasitisms1575506parasit____isms_
parasitoids1493306parasit__o_i_ds_
parasitoses1384646parasit__o__ses_
parasitosis13103986parasit__o__sis_
partitionists1554766par_tit_ionists_
pathologists1848376p__a_thologists_
pharmacologists2573646phar_macologists_
philologists1876686p___hilologists_
phraseologies1953276phras_eologi_es_
phrenologists1956296phr__enologists_
physiologist21157326p_hysi_ologist__
planetologist1664506p_lanetologist__
primatologist18175316p_rimatologist__
proctologist1758966p_r_octologist__
prologists13311176p_r____ologists_
pteridologists18133726p_teridologists_
radiologist1399496__radi_ologist__
sinologists1257676____sinologists_
teratologist13108576tera__tologist__
thanatologists1852866_thanatologists_
tribologists1546166_tr__ibologists_

Search took 6 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 Filter178691658740.343520965.0
2DLD Change Limit65874684.83013638.5
3Display Results68680.076894.7
 (SQL Overall)178691685.24934042.9
 
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.