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

95 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
peridotites145425(None) 
peridotite1354921peridotite_
peridotitic1653032peridotitic
lepidolites1452413lepidolites
peridotic1446483peridoti__c
peridots1138323perido__t_s
periodates1347863peri_odates
periostitis1354143periostitis
peripeties1448393peripeti_es
peritonitis1355103peritonitis
pyridoxines2452123pyridoxines
pyrrhotites1951623pyrrhotites
acridities1348294acriditi_es
aerolites9312584aer__olites
aridities10911634_ariditi_es
biotites10310084__bi_otites
carnotites1246544car_notites
derivatives1844644derivatives
derivatizes2445154derivatizes
epidotes1147024_epido__tes
epizoites2043694_epizo_ites
erotizes17311214_er__otizes
ferities111416714feri__ti_es
fervidities1863944ferviditi_es
fetidities1447874fetiditi_es
gelidities1247204geliditi_es
helictites1544654heli_ctites
heredities1447224herediti_es
lepidolite1352644lepidolite_
lepidotes1244304lepido__tes
merozoites2142984merozo_ites
parities10522974pari__ti_es
parotitis1149174par__otitis
pegmatites1544754pe_gmatites
perborates1459214per_borates
percentiles1546204percentiles
percolates14410424per_colates
perditions1348874per_ditions
perfectives2145474perfectives
perfidies1546604perfid__i_es
perforates1558864per_forates
pericopes1547874perico__pes
peridot10514244perido__t__
perigynies1643964perigyni_es
perimetries1547784perimetries
periodate1248344peri_odate_
periodicities1854904periodicities
periodids1345644peri_odi_ds
periodontics1762434periodonti_cs
periodontists1662544periodontists
periostea1144794peri_o_stea
periostitises1553124periostitises
periotic12313444peri_oti__c
peripatuses1552904peripatuses
peripetias1446304peripeti_as
peristomes1446054peri_stomes
peristyles1543864peri_styles
peritonitises1573324peritonitises
perlites10316364per___lites
perorates11417024per__orates
perovskites2051314perovskites
peroxides1947494per__oxides
perquisites2252814perquisites
personates122510694per_sonates
petites93820204pe____tites
pisolites1149384p__isolites
preinvites1564804prei_nvites
primitives1745624p_rimitives
priorates11410764p_ri_orates
priories10312454p_ri_ori_es
priorities1249154p_ri_orities
privatises15187404p_rivatises
privatives18186474p_rivatives
privatizes24156814p_rivatizes
privities14312044p_riviti_es
proustites1246454p_roustites
pteridines1345464pterid__ines
pteridophytes2471584pteridophytes
puerilities1347534pueriliti_es
purities10316284puri__ti_es
putridities1444914putriditi_es
pyridines1546474pyrid__ines
pyridoxine2352334pyridoxine_
pyridoxins2352294pyridoxi_ns
pyrrhotite1851944pyrrhotite_
ridottos943034__ridot_tos
sepiolites1246014sepi_olites
serotines9312074ser__otines
tepidities1347714tepiditi_es
tricotines1247454_tricotines
trilobites1244384_trilobites
variolites1346674vari_olites
veritates12310974veri__tates
verities111418044veri__ti_es
viridities14106904viriditi_es

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.406440125.6
2DLD Change Limit148819958.89316734.4
3Display Results95950.0462065.2
 (SQL Overall)178691959.34519121.6
 
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.