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

221 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
prelects129972(None) 
praelects1354351praelects
preelects1356081preelects
prefects1598131prefects
prelect111013831prelect_
elects83315002__elects
perfects15107352perfects
praefects1642872praefects
praelect1247532praelect_
preacts113211362pre_acts
precents123015042precents
precepts14268892precepts
predicts1339612predicts
preelect1249642preelect_
preerects1345412preerects
prefect141011072prefect_
preheats1339412preheats
prelected1439132prelected
prelector1348092prelector
prelectors1447872prelectors
preselects1464362preselects
presents103315642presents
presets94216422prese_ts
pretests10310012pretests
pretexts1735602pretexts
prevents133012292prevents
projects1936412projects
prosects1239472prosects
protects1239742protects
reelects103110882reelects
refects124012742_refects
reflects13288872_reflects
rejects163910692_rejects
relents74018502_relents
relets64025672_rele_ts
relicts94414592_relicts
relucts9369672_relucts
resects94115592_resects
selects91912142_selects
acrolects1344333acrolects
analects1047703analects
arbelests1143653arbelests
armlets94610063armle_ts
brevets12519393breve_ts
coerects1258543coerects
collects12279783collects
defects134511523_defects
deflects14336733deflects
dejects17389223_dejects
delicts104012253_delicts
derelicts12154183derelicts
deselects1244493deselects
detects104011093_detects
dialects11126003dialects
ejects15409953__ejects
elect74327033__elect_
erects84116183__erects
eyelets1057523eyele_ts
greets75117423gre_e_ts
inflects1336193inflects
ireless72312243irele_ss
neglects1144383neglects
omelets938333omele_ts
palets85122313p_ale_ts
pallets93919303palle_ts
pandects1335843pandects
partlets102811513partle_ts
peelers93615593peele_rs
peles75738083p_ele__s
pellets94014783p_ellets
pelmets11309693p_elmets
pelts76128813p_el__ts
percents122713373percents
percepts14247643percepts
perfect141010833perfect_
perfecta15115203perfecta
perfectas16135073perfectas
perfecto15105743perfecto
perfectos16106073perfectos
perpents122312043perpents
perverts1337533perverts
piglets103311793pigle_ts
piolets93513193piole_ts
pleats85218593p__leats
polecats1248833p_olecats
praefect1544773praefect_
praelected1544393praelected
preact103220393pre_act_
preallots1144513preallots
prebends13347883prebends
prebless1236823preble_ss
precasts1239453precasts
precedes13310713precedes
precent113520263precent_
precept133112513precept_
precess11310863prece_ss
prechecks2243573prechecks
precincts1544993precincts
precis103416703pr__ecis
precleans1344893precleans
preclears1344373preclears
precuts111710473pre_cuts
predeath1447003predeath
predeaths1544743predeaths
prededucts1642223prededucts
predict12315323predict_
preedits1168763preedits
preelected1545783preelected
preempts1444543preempts
preenacts1345843preenacts
preens85020113pre_e_ns
preerect1259273preerect_
prees75937173pre_e__s
prefaces15311063prefaces
prefers123713333prefe_rs
prefocus1544743prefocus
preheat12413893preheat_
prelacies13310053prelacies
prelacy1437583prelac_y
prelate9519693prel_ate
prelates10418573prelates
prelecting15310163prelecting
prelection141511293prelection
prelections151210473prelections
prelegal1145053prelegal
prelimits1366013prelimits
prelims1139823prel_ims
prelives13310383prelives
preloads1157513preloads
prelocate13109513prelocate
prelocates1468353prelocates
preludes1137833preludes
premeds12389593preme_ds
premeet11615153premeet_
prepacks1836583prepacks
preplaces1578753preplaces
prepuces1438583prepuces
prerectal1345693prerectal
preselect1346983preselect_
presells1058283presells
presences132113793presences
present94022733present_
preset84430983prese_t_
presifts1366593presifts
preslices1338213preslices
presorts105311683presorts
prests84021263pr__ests
preteens1038123preteens
pretells1047333pretells
pretences132312613pretences
pretends11299113pretends
preterits11410963preterits
preterms1237223preterms
pretest9517633pretest_
pretext1639663pretext_
pretreats1146933pretreats
prevalents1594973prevalents
prevent124016553prevent_
preverbs15295303preverbs
prexes154915953prexe__s
preyers124412363preye_rs
prezes173614693preze__s
priests93810863pr_iests
privets122910053prive_ts
products1376513products
project1838453project_
projets1639163proje_ts
prolegs10379993prole_gs
proles84627203prole__s
prosect11313393prosect_
prospects1545103prospects
protect11313633protect_
protests10310493protests
pullets94015163pulle_ts
reacts83616603_re_acts
rebecks15288013_rebecks
rebecs103913673_rebec_s
recepts113010263_recepts
redacts10510943_redacts
reejects17336083reejects
reelect911515633reelect_
reerects10319923reerects
reests64618893_re_ests
refect114319333_refect_
reflect123913713_reflect_
reflets103513153_refle_ts
regents83416543_regents
reglets83512983_regle_ts
reheats104513523_reheats
reject154116283_reject_
relaces93420883_relaces
relends84013253_relends
relent64431853_relent_
relet54749823_rele_t_
releves103914973_releves
relics84517903_relic_s
relict83623903_relict_
relists73817053_relists
relocks134411293_relocks
reluct83916113_reluct_
remeets93712413_remeets
remelts93511493_remelts
renests74014213_renests
repeats94316053_repeats
repents93717623_repents
rerents73319423_rerents
reseats74319583_reseats
resect84424703_resect_
reselects1156413reselects
resents74221223_resents
resets65427613_rese_ts
respects1247703_respects
retests73813853_retests
reverts104715043_reverts
revests104413733_revests
revets94022173_reve_ts
rewets94617213_rewe_ts
select82621173_select_
trajects1744533trajects
trevets10499973treve_ts
trisects1035983trisects

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.483369960.7
2DLD Change Limit1461622218.08018089.4
3Display Results2212210.1701300.0
 (SQL Overall)1786912218.73320461.6
 
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.