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

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

64 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
parasitoids149330(None) 
parasitoid13114531parasitoid_
parasitoses1384642parasitoses
parasitosis13103982parasitosis
paraboloids1653043paraboloids
paranoids1248913para__noids
parasites11313153parasit__es
parasitic1349523parasit_i_c
parasiticide17112253parasiticide
parasiticides18111943parasiticides
parasitise1277403parasit_ise
parasitises1377373parasitises
parasitism1466593parasit_ism
parasitisms1575503parasitisms
parasitize2165863parasit_ize
parasitizes2266103parasitizes
parotoids1256963par__otoids
arachnoids1663374_arachnoids
carcinoids1584464car_cinoids
cardioids1345244car_di_oids
carotinoids1452594carotinoids
granitoid1174684_granitoid_
marasmoid1443294maras_moid_
mastoids1177874__mas_toids
parabioses1445284parabi_oses
parabiosis1444904parabi_osis
parabiotic1645084parabioti_c
paraboloid1554084paraboloid_
parafoils1445504para__foils
parakites1549544parakit__es
paralytics1745204paralyt_ics
paranoias11410444para__noias
paranoics1347654para__noics
paranoid11311144para__noid_
parasails1147584paras__ails
parasite10314844parasit___e
parasitical1555654parasitical
parasiticidal1861304parasiticidal
parasitised1474854parasitised
parasitising1553464parasitising
parasitized2364734parasitized
parasitizing2454044parasitizing
parasitologies1782364parasitologies
parasitology1862534parasitology
parasols1039264paras__o_ls
parathyroids2161594parathyroids
paratyphoids2361344paratyphoids
parities10522974par__it_ies
parotids112610414par__ot_ids
parotitis1149184parotit_i_s
parotoid11410034par__otoid_
parsimonies1553404par_simonies
partitions1248324par_titions
planetoids1344094p_lanetoids
plasmoids1444544p_las_moids
plastids11269214p_las_t_ids
platinoids1344004p_latinoids
porosities12411484porosit_ies
prismatoids1651974p_rismatoids
prismoids1443624p_ris_moids
pyralidids1752144pyrali_dids
resinoids1044704__resinoids
sparsities1247324spar_sit_ies
varsities1239244var_sit_ies

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819649.12616307.1
3Display Results64640.0302133.3
 (SQL Overall)178691649.57918654.5
 
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.