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

136 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
perfects1510735(None) 
perfect141010831perfect_
perfecta15115201perfecta
perfectas16135071perfectas
perfecto15105741perfecto
perfectos16106071perfectos
prefects1598131prefects
defects134511522de_fects
effects1535282_effects
erects84116182_er_ects
imperfects1942882imperfects
percents122713372percents
percepts14247642percepts
perfected1736632perfected
perfecter1646042perfecter
perfecters1745432perfecters
perfectest1744812perfectest
perfectly1944102perfectly
perpents122312032perpents
perverts1337532perverts
prefect141011072prefect_
prelects1299722prelects
refects124012742re_fects
affects1535393_affects
aperients1178253aperients
befrets1237613befre_ts
berets85822523ber_e_ts
cermets1139713cerme_ts
coeffects1942463coeffects
coerects1258543coer_ects
confects153110873confects
corrects1259573corrects
defeats113511233de_feats
defect124816173de_fect_
deflects14336733deflects
dejects17389223de_jects
detects104011093de_tects
directs102710263dir_ects
effect1437443_effect_
ejects15409953_e_jects
elects83315003_e_lects
erect74129333_er_ect_
eructs83610793_er_ucts
expects1866883_expects
exsects1655573_exsects
ferments13311473ferments
ferrets103111393ferre_ts
forfeits1445803forfeits
gerents82612923ger_ents
imperfect1844143imperfect_
infects12279713_infects
neglects1144383neglects
pandects1335843pandects
parents93418123par_ents
parfaits1346913parfaits
pargets105215193parge_ts
parsecs11429923parsec_s
pellets94014783pelle_ts
pelmets11309693pelme_ts
pendents1139413pendents
percent113520603percent_
percept133112523percept_
pereons92815003per_eons
peres76246643per_e__s
perfecting1847513perfecting
perfection1748363perfection
perfections1848123perfections
perfective2047193perfective
perfectives2145463perfectives
perfectness1853493perfectness
performs1547483performs
perfumes1555893perfumes
perfuses1358663perfuses
periapts1237273periapts
peridots1138323peridots
permeate12311613permeate
permeates13311773permeates
permits11314003per_mits
perpends13227743perpends
perpent112318803perpent_
persalts1038193persalts
persecute1344883persecute
persecutes1444353persecutes
perses85428063perse__s
persists1049183persists
pertest9317043pertest_
pervert12315583pervert_
pluperfects205693pluperfects
porrect1159743porrect_
portents103512823portents
praefects1642873praefects
preacts113211363p_reacts
precents123015043precents
precepts14268883precepts
precis103416703p_r_ecis
precuts111710473p_r_ecuts
predicts1339613predicts
preelects1356083preelects
preerects1345413preerects
prefaces15311063prefaces
prefers123713333prefe_rs
prefocus1544743prefocus
preheats1339413preheats
prelect111013833prelect_
presents103315643presents
presets94216423prese_ts
prests84021263p_r_ests
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
priests93810863p_riests
projects1936413projects
prosects1239473prosects
protects1239743protects
redefects1543793redefects
reejects17336083reejects
reelects103110883reelects
reerects10319923reerects
refect114319333re_fect_
reflects13288873reflects
refracts13137383refracts
reinfects1444723reinfects
rejects163910693re_jects
rerents73319423rer_ents
resects94115593re_sects
respects1247703respects
selects91912143se_lects
serpents102410373serpents
surfeits1146223surfeits
tercets93512443terce_ts
terrets72913573terre_ts
unperfect1643643unperfect_
verdicts1446013verdicts
versets103913103verse_ts
vervets13419753verve_ts
wergelts1253413wergelts

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.1701051123.5
2DLD Change Limit1461621367.98618302.3
3Display Results1361360.0602266.7
 (SQL Overall)1786911368.21621749.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.