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

177 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
praetors103983(None) 
praetor938971praetor_
pretors9316811pr_etors
creators102814412creators
grantors93810352grantors
orators7313822ora_tors
pastors94119002p_astors
phaetons1345852phaetons
praters94921652pra_ters
pretor8315752pr_etor_
proctors12311512proctors
raptors94213352_raptors
rhetors1038512_rhetors
tractors10312562tractors
traitors8310792traitors
abators94413083aba_tors
actors81016763__actors
adaptors1145253adaptors
aerators8315613aera_tors
alastors8311203alastors
arrestors958033arrestors
barretors1146243barretors
cantors94620753_cantors
captors113914983_captors
castors94919443_castors
chantors133710263chantors
coactors1239473coactors
crafters13419953crafters
craters95021893cra_ters
cratons94316033cra_tons
creator93714443creator_
curators10311723cura_tors
drafters12338523drafters
enactors1038453enactors
erectors103514263erectors
exactors1737013exactors
factors12912123_factors
fetors91014473__fetors
foetors1039763_foetors
fracturs13146313fracturs
frakturs15163263frakturs
fraters103517213fra_ters
gators74115833_ga_tors
grafters12409193grafters
granters93614143granters
grantor84010933grantor_
graters85419743gra_ters
greeters92610113greeters
gyrators1245993gyra_tors
kraters114212343kra_ters
operators11410753opera_tors
orator6314533ora_tor_
oratory1039403ora_tory
paeons83915523p_ae_ons
paletots1047803paletots
pallors9314363p_allors
palters94021683p_alters
pantos85222743p_anto_s
parachors1647403parachors
paradors113411903paradors
parameters1448123parameters
pareos87023773pare_o_s
parers85530743pare__rs
paretics122312443paretics
parlors9312913p_arlors
partons94620513p_artons
pasters94531733p_asters
pastor84817483p_astor_
patentors1146743patentors
paters84935833p_a_ters
patois84319363p_a_tois
patters94825193p_atters
paviors1237603p_aviors
pawnors12297203p_awnors
payors114312643p_a_yors
permeators1447403permeators
peters86624593p__eters
phaeton1235973phaeto_n
phantoms1545973phantoms
piasters102912813piasters
plaiters103512633plaiters
planters102915323planters
plasters103518133plasters
platers93924093pla_ters
platters103415283platters
pleaters103613793pleaters
plexors1645423p_lexors
praetorial1257093praetorial
praetorian1256633praetorian
praetorians1364623praetorians
praetorship1854643praetorship
praisers103410833praisers
prancers123210333prancers
praos74923563pra__o_s
prater84825353pra_ter_
prates84633163pra_t_es
prats76333393pra_t__s
prattlers11195323prattlers
prattles10189403prattles
prawners1346003prawners
prayers124212853pra_yers
prealters1147773prealters
preavers13910263preavers
precentors1488343precentors
preceptors1657053preceptors
predators12310083predators
preemptors1644233preemptors
preeners102712813preeners
prefers123713333pr_efers
preform1439613pr_eform
preforms1537403pr_eforms
prelectors1447873prelectors
premorse1237553pr_emorse
preops104911943pr_e_ops
presort95219543pr_esort
presorts105311683pr_esorts
pressors103212693pressors
presters103419003presters
prestore104217353prestore
prestores114716083prestores
prestos93716083presto_s
preterm11310163pr_eterm
preterms1237223pr_eterms
pretold1049083pr_etold
prework164210913pr_ework
preworks17599013pr_eworks
preworn124711223pr_eworn
preyers124412363pr_eyers
priers84521193prie__rs
printers103214903printers
priors83914483pr__iors
proctor11310433proctor_
proettes10312763proettes
projectors21187173projectors
pronators11411303pronators
propraetors1554183propraetors
propretors1445793propretors
prosectors14199123prosectors
protectors142010143protectors
protestors12169313protestors
protons93118003pr_otons
pryers115012243prye__rs
psalters10227713psalters
purveyors1741663purveyors
quaestors1843613quaestors
rafters103715633_rafters
ragtops1035453_ragtops
rancors9811373_rancors
ranters73323643_ranters
raptor83912823_raptor_
rasters74629023_rasters
raters63936583_ra_ters
ratos55528763_ra_to_s
ratters74422473_ratters
rattons73815323_rattons
razors154711663_ra_zors
reactors103212283reactors
realtors82811683realtors
rectors93520523_rectors
retore67630773_r_etore
retorn610923433_r_etorn
retort66831153_r_etort
retorts76016513_r_etorts
retros63820193_r_etros
rhetor938063_rhetor_
rotors64917953_r_otors
sartors7314973_sartors
stators73915583sta_tors
tractor9311333tractor_
traitor7310123traitor_
treaters83615843treaters
treetops1045463treetops
tremors93711233tr_emors
trustors8268913trustors
ureters7311823ur_eters
varactors1446393varactors
viators102712023via_tors

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 Limit1461621777.37619815.9
3Display Results1771770.0762328.9
 (SQL Overall)1786911777.87222699.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.