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

198 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
prefects159813(None) 
perfects15107351perfects
praefects1642871praefects
prefect141011071prefect_
prelects1299721prelects
refects124012741_refects
defects134511522_defects
perfect141010832perfect_
perfecta15115202perfecta
perfectas16135072perfectas
perfecto15105742perfecto
perfectos16106072perfectos
praefect1544772praefect_
praelects1354352praelects
preacts113211362pre_acts
precents123015042precents
precepts14268892precepts
predicts1339612predicts
preelects1356082preelects
preerects1345412preerects
prefaces15311062prefaces
prefers123713332prefe_rs
prefocus1544742prefocus
preheats1339412preheats
prelect111013832prelect_
presents103315642presents
presets94216422prese_ts
pretests10310012pretests
pretexts1735602pretexts
prevents133012292prevents
projects1936412projects
prosects1239472prosects
protects1239742protects
refect114319332_refect_
reflects13288872_reflects
rejects163910692_rejects
resects94115592_resects
affects1535393_affects
artefacts1443153artefacts
brevets12519393breve_ts
coeffects1942463coeffects
coerects1258543coerects
confects153110873confects
defeats113511233_defeats
defect124816173_defect_
deflects14336733_deflects
dejects17389223_dejects
detects104011093_detects
effects1535283_effects
ejects15409953__ejects
elects83315003__elects
erects84116183__erects
greets75117423gre_e_ts
imperfects1942883imperfects
infects12279713_infects
pandects1335843pandects
percents122713373percents
percepts14247643percepts
perfected1736633perfected
perfecter1646043perfecter
perfecters1745433perfecters
perfectest1744813perfectest
perfectly1944103perfectly
perpents122312033perpents
perverts1337533perverts
pieforts1344863pieforts
praelect1247533praelect_
preact103220393pre_act_
prebends13347883prebends
precasts1239453precasts
precedes13310703precedes
precent113520263precent_
precept133112513precept_
precess11310863prece_ss
prechecks2243573prechecks
precincts1544993precincts
precis103416703pr__ecis
precuts111710473pre_cuts
predeath1447003predeath
predeaths1544743predeaths
prededucts1642223prededucts
predict12315323predict_
preedits1168763preedits
preelect1249643preelect_
preempts1444543preempts
preenacts1345843preenacts
preens85020113pre_e_ns
preerect1259273preerect_
prees75937173pre_e__s
prefabs1435163pref_abs
preface14510923prefac_e
prefaced1638423prefaced
prefacer1537983prefacer
prefacers1636293prefacers
prefades1439533prefades
prefecture1744803prefecture
prefectures1844303prefectures
prefer113813203prefe__r
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
preforms1537393preforms
prefunds1454693prefunds
preheat12413893preheat_
prelected1439123prelected
prelector1348093prelector
prelectors1447863prelectors
premeds12389583preme_ds
premeet11615153premeet_
prepacks1836583prepacks
prepuces1438583prepuces
prerectal1345693prerectal
preselects1464363preselects
presells1058273presells
presences132113793presences
present94022733present_
preset84430983prese_t_
presifts1366593presifts
presorts105311683presorts
prests84021263pr__ests
preteens1038123preteens
pretells1047323pretells
pretences132312613pretences
pretends11299113pretends
preterits11410963preterits
preterms1237223preterms
pretest9517633pretest_
pretext1639663pretext_
pretreats1146933pretreats
prevent124016553prevent_
preverbs15295303preverbs
prexes154915943prexe__s
preyers124412363preye_rs
prezes173614693preze__s
priests93810863pr_iests
privets122910053prive_ts
products1376513products
profess1237713profe_ss
profits122911243prof_its
project1838453project_
projets1639163proje_ts
prosect11313393prosect_
prospects1545103prospects
protect11313633protect_
protests10310493protests
reacts83616603_re_acts
rebecks15288013_rebecks
rebecs103913673_rebec_s
recepts113010263_recepts
redacts10510943_redacts
redefects1543793redefects
reejects17336083reejects
reelects103110883reelects
reerects10319923reerects
reests64618893_re_ests
refaces123216743_refaces
refected142311663_refected
refeeds11368973_refeeds
refeels10379693_refeels
refels94618053_refe_ls
refelt94521423_refelt_
refences13311843_refences
refers93921083_refe_rs
refits94017653_ref_its
reflect123913713_reflect_
reflets103513153_reflets
refocus1236973_refocus
refracts13137383_refracts
regents83416543_regents
reheats104513523_reheats
reinfects1444723_reinfects
reject154116283_reject_
relents74018503_relents
relets64025673_rele_ts
relicts94414593_relicts
relucts9369673_relucts
remeets93712413_remeets
remelts93511493_remelts
renests74014213_renests
repeats94316053_repeats
repents93717623_repents
rerents73319423_rerents
reseats74319583_reseats
resect84424703_resect_
resents74221223_resents
resets65427613_rese_ts
respects1247703_respects
retests73813853_retests
reverts104715043_reverts
revests104413733_revests
revets94022173_reve_ts
rewets94617213_rewe_ts
selects91912143_selects
trajects1744533trajects
trevets10499973treve_ts
trifecta1343573trifecta
trifectas1443653trifectas
trisects1035983trisects

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.1561145455.1
2DLD Change Limit1461621986.81321453.4
3Display Results1981980.0762605.3
 (SQL Overall)1786911987.04525364.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.