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 “pageants” 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
pageants113669(None) 
pageant10312781pageant_
agents74816292_age_nts
paeans85118262pa_ean_s
pagans95717922pag_an_s
pageantry1542322pageantry
parents93418122pare_nts
patents94815202pate_nts
taggants1044932taggants
vagrants1246142vagrants
ageings9437693_ageings
ageists848493_ageists
agenes74720253_age_nes
agent65829643_age_nt_
alants67722023_a_lants
aments85219803_ame_nts
argents84014853arge_nts
callants104112143callants
caveats1239803cavea_ts
coagents1138453coage_nts
faineants1243273faineants
gallants93310373gallants
gelants82611443__gelants
gents65729613__ge_nts
giants74713503__giants
grants73722473__grants
lagans75717783lag_an_s
lagends947273lage_nds
laments94314853lame_nts
latents75214313late_nts
magenta1038623mage_nta
magentas1137923mage_ntas
magians10310753magian_s
margents11410133marge_nts
migrants1138183migrants
naganas847983nag_anas
nauseants943053nauseants
orgeats838353orgea_ts
paean77222723pa_ean__
paeanism1248703pa_eanism
paeons83915523pa_eon_s
paesanos10296703paesanos
paesans93312693paesan_s
pagan86121163pag_an__
paganise1139663pag_anise
paganish1447773pag_anish
paganism1369113pag_anism
paganist11411813pag_anist
paganists1247643pag_anists
pageantries1452983pageantries
pageboys1643183pageboys
pagefuls1474343pagefuls
pagers94423253page__rs
pages85235073page___s
paginate114012443paginate
paginates123111363paginates
pagings114411063pag_ings
paints85921833pa__ints
paisanas10288873paisanas
paisanos10337553paisanos
paisans93614753paisan_s
paleate94120003palea_te
paletots1047803paletots
palets85122313pale__ts
pampeans1444703pampean_s
pandanus1136433pandanus
pangenes112612823pange_nes
pangens103112063pange_n_s
pants76536923p___ants
parangs104314373pa_rangs
parent83230423pare_nt_
parfaits1346913parfaits
pargets105215193parge__ts
parians93519733parian_s
parlante1039693parlante
partans94418283partan_s
passant9813943passant_
patens84820863pate_n_s
patent84524923pate_nt_
patients1088763patients
pavanes123612653pa_vanes
pavans115715593pa_van_s
pavements1647003pavements
payments1536943payments
peans75437643p__ean_s
peanuts936993p__eanuts
peasants1038263peasants
peats76140193p__ea_ts
pedants10310113p_edants
pendants1139093pendants
pennants1037063pennants
pigeons1039183pigeon_s
pigments1337343pigments
pissants1097363pissants
plants84921803p__lants
pleats85218593p_lea_ts
preacts113211363p_reacts
radiants9259443radiants
raglans82410133raglan_s
reagents959623reage_nts
regents83416543rege_nts
regrants9310013regrants
savants1038653sa_vants
sergeants10115593sergeants
taggant9310223taggant_
talents7312013tale_nts
tangents938713tange_nts
vagrant11410663vagrant_
valiants1137793valiants
variants1139203variants
warrants1168503warrants

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.420425454.8
2DLD Change Limit1461621116.51622431.2
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.98225593.1
 
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.