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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
pandects133584(None) 
pandect12310951pandect_
panders103423732pande_rs
pandits103914212pand_its
pendents1139412pendents
abducts1265313_abducts
addicts1176013_addicts
adducts1174603_adducts
adepts9117103_a_depts
advects13276013_advects
affects1535393_affects
analects1047703_analects
aspects1146743_aspects
bandeaus1146503bandeaus
banders104324563bande_rs
bandits103814793band_its
bannets94013843banne_ts
cadets96316513ca_de_ts
candelas1139533candelas
candent10417363candent_
cathects1545793cathects
conducts13118713conducts
confects153110873confects
connects123010563connects
convects153410993convects
damndests1392793damndests
danders93921183dande_rs
darndests1183143darndests
fanjets1734803fanje_ts
ganders93521703gande_rs
gannets83811443ganne_ts
handers114224333hande_rs
handouts1238233handouts
handsets12258343handsets
indents83114663_indents
indicts103210723_indicts
inducts10259573_inducts
infects12279713_infects
injects16257453_injects
insects93710843_insects
lancets93411163lance_ts
landers84026213lande_rs
packets155114773packe_ts
pacts95125803pa___cts
padders113312873padde_rs
paddocks1894323paddocks
palets85122313pa_le_ts
pallets93919303palle_ts
panaceas1236763panaceas
pancetta1244653pancetta
pancettas1343993pancettas
pandanus1136433pandanus
pandas95521963pand__as
pandemic1545543pandemic
pandemics1643933pandemics
pander93725523pande__r
pandered121812573pandered
panderer112210913panderer
panderers12229153panderers
pandies104224503pand_ies
pandit93820753pand_it_
pandoors11258983pandoors
pandoras11310053pandoras
pandores11312453pandores
pandours11317993pandours
panduras1136953panduras
panels84716523pan_e_ls
panes76148693pan_e__s
pangenes112612823pangenes
pangens103112063pange_ns
panics103815363pan_ic_s
paniers94717333panie_rs
panners93621273panne_rs
pannes85522853panne__s
pants76536923pan___ts
panzers184012013panze_rs
parents93418123pa_rents
pargets105215193parge_ts
parsecs11429923parsec_s
patents94815203pa_tents
patients1088763patients
payments1536943payments
pendants1139093pendants
pendent10314723pendent_
perfects15107353perfects
pinders103720473pinde_rs
planets93914083plan_e_ts
ponders103618843ponde_rs
praefects1642873praefects
praelects1354353praelects
predicts1339613predicts
prefects1598133prefects
prelects1299723prelects
products1376513products
projects1936413projects
prosects1239473prosects
protects1239743protects
pundits10379293pund_its
punnets9409263punne_ts
sanders84025943sande_rs
sandlots938293sandlots
sandpits1146843sandpits
spandexes1943453spandexes
sundecks1544253sundecks
syndets1136113synde_ts
tandems1037633tande_ms
tangents938713tangents
tanrecs934823tanrec_s
transects1157823transects
wanders114221333wande_rs
zanders173015793zande_rs

Search took 7 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.1561145455.1
2DLD Change Limit1461621116.47022590.7
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.67226782.2
 
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.