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

75 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
periodid1248161periodid
periotic12313441periotic
parotid102915512par_otid
percoid12312322perco_id
peridotic1446482peridotic
period9314982perio__d
periodic1348432periodic
periodids1345642periodids
periti8319952peri_ti_
peroxid17310282per_oxid
aperiodic1444073aperiodic
aperitif1347353aperi_tif
carotid102014833car_otid
ceratoid1149923ceratoid
cerotic11415063cer_otic
dermoid1138523dermo_id
ergotic1049723_ergotic
ericoid1049893_ericoid
eristic9814093_eristic
erotic82620273_er_otic
heriot9422343heriot__
heriots10312063heriot_s
keratoid1347273keratoid
meiotic11410933me_iotic
meristic12311253meristic
merited10313853meri_ted
neritic91314333neri_tic
parotic112518043par_otic
parotids112610413par_otids
parotoid11410033par_otoid
parroted1158853parroted
patriotic13107593patriotic
pelitic111814653peli_tic
peptid112712373pe__ptid
peracid12312993per_acid
percoids1339663perco_ids
pereiopod1452733pereiopod
pereopod1344933pereopod
pericopic1745543pericopic
peridia10312373peri_dia
peridot10514243peridot__
peridotite1354923peridotite
peridots1138323peridot_s
periled10316323peri_led
perilled11410113perilled
periods10312243perio_ds
periostea1144793periostea
peripetia1346663peripetia
peripter1278753peripter
perished14310093perished
peritus9311803peri_tus
periwig1345163peri_wig
perlitic12310583perlitic
permitted1446653permitted
permuted1336713permuted
pernod9310453perno__d
peroxide1848193per_oxide
peroxids1837453per_oxids
persisted1247153persisted
petioled1137993petioled
prebiotic1545413prebiotic
preriot9316413preriot__
printed104016373p_rinted
proteid103513673p_r_oteid
puristic1239383puristic
pyritic143311313pyri_tic
rioted73416373__rioted
semiotic12710633semiotic
seriated92717023seriated
seriatim1049223seriatim
spermatid1448043spermatid
teratoid9411073teratoid
trioxid1546613_trioxid
veristic1339883veristic
xerotic16410863xer_otic

Search took 8 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.423422437.4
2DLD Change Limit146162757.03020791.2
3Display Results75750.0332272.7
 (SQL Overall)178691757.48623870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.