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

69 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
parasitologist176325(None) 
parasitologists1862801parasitologists
parasitologic1862252parasitologi_c
parasitologies1782362parasitologies
parasitological2062773parasitological
parasitology1862533parasitolog__y
phraseologist1954193phras_eologist
cardiologist1656624car_di_ologist
malariologist1693924malari_ologist
narratologist1453834nar_ratologist
paleontologist1765144paleontologist
parasitosis13103984parasit__osis_
phraseologists2053574phras_eologists
physiologist21157324p_hysi_ologist
planetologist1664504p_lanetologist
primatologist18175314p_rimatologist
proctologist1758964p_r_octologist
radiologist1399494__radi_ologist
teratologist13108574tera__tologist
archaeologist19113495_archaeologist
audiologist1347245_a_udi_ologist
cardiologists1765145car_di_ologists
criminologist1863645_criminologist
cryptologist2056435_cr_yptologist
dermatologist1786465der_matologist
diabetologist17133145_diabetologist
gerontologist1555985ger_ontologist
glaciologist1654895_glaci_ologist
graphologist19114865_gra_phologist
hematologist18219205hema__tologist
herpetologist1984795her_petologist
histologist1547985__his_tologist
iridologist1345795_ir__idologist
malacologist1755635mala__cologist
malariologists1773355malari_ologists
martyrologist1953325mar_tyrologist
musicologist1754285__musicologist
narratologists1553215nar_ratologists
nematologist15208475nema__tologist
ornithologist1753325_or_nithologist
paleobiologist19156345paleobiologist
paleoecologist19114725paleoecologist
paleontologists1884525paleontologists
paleozoologist2664195paleozoologist
palynologist1856305p__alynologist
papyrologist2055095p__apyrologist
paralogism1545665para____logism
parasitise1277405parasit____ise
parasitism1466595parasit____ism
parasitoid13114535parasit__o_i_d
parasitoids1493305parasit__o_ids
parasitoses1384645parasit__oses_
partitionist1456265par_tit_ionist
pathologist17410665p__a_thologist
pharmacologist2464175phar_macologist
philologist1768435p___hilologist
phraseologies1953275phras_eologies
phrenologist1857915phr__enologist
physiologists22156015p_hysi_ologists
planetologists1763625p_lanetologists
primatologists19184355p_rimatologists
proctologists1856815p_r_octologists
prologist12315085p_r____ologist
pteridologist17144605p_teridologist
radiologists1497365__radi_ologists
sinologist11510665____sinologist
teratologists1496595tera__tologists
thanatologist1753615_thanatologist
tribologist1447725_tr__ibologist

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 Filter178691950240.356501941.0
2DLD Change Limit95024698.36011366.5
3Display Results69690.0461500.0
 (SQL Overall)178691698.76220393.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.