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

143 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
pendants113909(None) 
pedants10310111pe_dants
pendant10314851pendant_
pendents1139411pendents
pennants1037061pennants
appendants1544062appendants
dependants1444702dependants
fondants1246202fondants
pandanus1136432pandanus
peasants1038262peasants
pedant9319492pe_dant_
penangs10268372pen_angs
penchants1646192penchants
pendantly1545462pendantly
pendent10314722pendent_
pennant9312492pennant_
pentanes10316082pentanes
tenants7311012ten_ants
andante8311273_andante
andantes9310853_andantes
appendant1455733appendant_
appendents1544403appendents
ascendants1343613ascendants
attendants1143683attendants
bandanas11178573bandanas
bendays13327513benda_ys
bezants1877343be_zants
bezzants1843643bezzants
decants103514443de_cants
dedans85915073de_dan_s
defendants1543653defendants
demandants1443253demandants
deodands1144603deodands
dependant1346993dependant_
dependents1446163dependents
descants112910143descants
deviants1236733deviants
eluants737583_eluants
enacts84012973_en_acts
enchants1347823_enchants
endings92910443_endings
entrants8311753_entrants
errants7410643_errants
fenlands1245183fenlands
fondant11311143fondant_
gelants82611443ge_lants
gellants9308283gellants
henbanes1336573henbanes
incants92012803_incants
indents83114663_indents
infants102210773_infants
intendants1145253intendants
levants1037723le_vants
lindanes939173lindanes
mediants11299493mediants
mendicants1553943mendicants
mendings12338303mendings
mordants1137143mordants
operants1039483ope_rants
oxidants1643933oxidants
pageants1136693pageants
pandani1039903pandan_i
pandas95521963panda__s
pandects1335843pandects
pandits103914213pand_its
pants76536923p___ants
peans75437643pe__an_s
peanuts936993pe__anuts
peasant9314923peasant_
peats76140193pe__a_ts
pecans101515833pe_can_s
peccant13311733peccant_
pechans14810503pechan_s
pedalos10329703pe_dalos
pedals94316033pe_da_ls
pedantic1346583pe_dantic
pedantry1444053pe_dantry
pedate93117763pe_da_te
pekans121710553pe_kan_s
peltasts1035703peltasts
penalty1267743pen_alty
penance11313443pen_ance
penances12312443pen_ances
penang92511113pen_an_g
penates93321593pen_ates
penchant1549573penchant_
pendency1646073pendency
pendently1546603pendently
pending114119773pendin_g
pends85527193pend___s
penetrants1245273penetrants
penitents1147703penitents
penman10312323penman__
pennames12287793pennames
pennate93314033penna_te
pennines103112043pennines
pennis84315743pen__nis
pennons939713pennon_s
penpoints1344553penpoints
pentads1039523penta_ds
pentane9415743pentan_e
pentanol1046173pentanol
pentanols1146113pentanols
pentenes10315633pentenes
penults937123pen_ults
percents122713373percents
perianth1348553perianth
perianths1445473perianths
periapts1237273periapts
perpents122312033perpents
persalts1038193persalts
pheasants1443723pheasants
pieplants1355433pieplants
pinangs10267793pin_angs
pintanos10107553pintanos
pissants1097363pissants
plants84921803p__lants
preadapts1444003preadapts
pundits10379293pund_its
randans8313213randan_s
readapts1145583readapts
recants93217093re_cants
redacts10510943re_dacts
redans75421023re_dan_s
regrants9310013regrants
remnants1036843remnants
replants102811243replants
sealants82610743sealants
seawants11337973seawants
secants93413893se_cants
sedans74816093se_dan_s
sendals81912263senda_ls
servants1137993servants
sextants15287383sextants
sonants7511233son_ants
tenant6322473ten_ant_
tendance1147523tendance
tendances1247573tendances
tendons8311473tendon_s
vendaces1457183vendaces
verdant11313293verdant_
versants1137783versants
zenanas16286233zen_anas

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621437.95318378.2
3Display Results1431430.0632269.8
 (SQL Overall)1786911438.17221866.3
 
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.