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

187 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
praetor93897(None) 
praetors1039831praetors
pretor8315751pr_etor
creator93714442creator
grantor84010932grantor
orator6314532ora_tor
pastor84817482p_astor
phaeton1235972phaeton
prater84825352pra_ter
pretors9316812pr_etors
proctor11310432proctor
raptor83912822_raptor
rhetor938062_rhetor
tractor9311332tractor
traitor7310122traitor
abator84512713aba_tor
actor71116073__actor
adaptor1034943adaptor
aerator7314843aera_tor
alastor739663alastor
arrestor847653arrestor
barretor1046713barretor
cantor85621523_cantor
captor104914603_captor
castor84418533_castor
chantor123710313chantor
coactor1139123coactor
crafter124111333crafter
crater85026643cra_ter
craton84517193cra_ton
creators102814413creators
curator9312213cura_tor
drafter11449433drafter
enactor938033enactor
erector93513813erector
exactor1636623exactor
factor11911453_factor
fetor81214533__fetor
foetor939563_foetor
fractur12135573fractur
fraktur14153043fraktur
frater94520593fra_ter
gator64416033_ga_tor
grafter114211153grafter
granter84117133granter
grantors93810353grantors
grater74625443gra_ter
greater84416493greater
greeter82812673greeter
gyrator1135713gyra_tor
irater65218353ira_ter
krater104014313kra_ter
operator10310093opera_tor
orators7313823ora_tors
oratory1039403ora_tory
paeon74819493p_ae_on
paletot9413713paletot
pallor8313673p_allor
palter84423263p_alter
panto76129413p_anto_
pantos85222743p_antos
parachor1546653parachor
parador103311413parador
parameter1349123parameter
pareo74632603pare_o_
pareos87023773pare_os
parer75839903pare__r
paretic113016673paretic
parlor8312673p_arlor
parton84720993p_arton
paster85734373p_aster
pastors94119003p_astors
patentor1046373patentor
pater74740723p_a_ter
patter84628263p_atter
pavior1138533p_avior
pawnor11357243p_awnor
payor105413843p_a_yor
pearter9412743pearter
permeator1347403permeator
peter74427593p__eter
phaetons1345853phaetons
phantom1436693phantom
phatter123810203phatter
piaster93012883piaster
plaiter93615393plaiter
plantar9369993plantar
planter94017803planter
plaster93318693plaster
plater84427693pla_ter
platter93917413platter
pleater93916333pleater
plexor1535253p_lexor
practic13312253practic
praetorial1257093praetorial
praetorian1256633praetorian
praiser93413943praiser
prancer113613383prancer
prao66229023pra__o_
praos74923563pra__os
prat65952043pra_t__
prate75135983pra_t_e
prated94924923pra_ted
praters94921653praters
prates84633163pra_tes
prats76333393pra_t_s
prattle9208833prattle
prattler10166343prattler
prawner1246803prawner
prayer114815293pra_yer
prealter1048863prealter
preaver121011613preaver
precentor1348733precentor
preceptor1547323preceptor
predator11310053predator
preemptor1544153preemptor
preener93114833preener
prefer113813203pr_efer
preform1439613pr_eform
prelector1348093prelector
preop94715873pr_e_op
presort95219543pr_esort
pressor93512883pressor
prester93519623prester
presto84216203presto_
prestore104217353prestore
prestos93716083prestos
pretax152310193pr_etax
preterm11310163pr_eterm
pretold1049083pr_etold
pretty11510873pr_etty
prewar114712583pr_ewar
prework164210913pr_ework
preworn124711223pr_eworn
preyer114413733pr_eyer
prier75027763prie__r
printer93917303printer
prior74316173pr__ior
proctors12311513proctors
proette9312363proette
projector20186683projector
pronator10311783pronator
pronto8313993pronto_
propraetor1454123propraetor
propretor1345533propretor
prosector13208533prosector
protector13169533protector
protestor11178493protestor
proton84318893pr_oton
prutot8311823pr_utot
pryer104415313prye__r
psalter9247813psalter
purveyor1641543purveyor
quaestor1743313quaestor
rafter94517583_rafter
ragtop936683_ragtop
rancor8810373_rancor
ranter63826823_ranter
raptors94213353_raptors
raster64731443_raster
rater54943283_ra_ter
rato45436973_ra_to_
ratos55528763_ra_tos
ratter64326313_ratter
ratton64116123_ratton
razor143012603_ra_zor
reactor93011653reactor
realtor73611353realtor
rector84019753_rector
retore67630773_r_etore
retorn610923433_r_etorn
retort66831153_r_etort
retro55020953_r_etro
rhetors1038513_rhetors
rotor55519733_r_otor
sartor6313883_sartor
stator64015483sta_tor
tractors10312563tractors
traditor945943traditor
traitors8310793traitors
treater74219833treater
treetop945523treetop
tremor84210403tr_emor
trustor7238413trustor
ureter6313203ur_eter
varactor1345693varactor
viator93211833via_tor

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271876.53320515.4
3Display Results1871870.0603116.7
 (SQL Overall)1786911876.98325589.4
 
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.