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

521 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
pirating1131451(None) 
prating103424451p_rating
aerating92821002aerating
airting83616302air_ting
aspirating1348362aspirating
berating113220762berating
borating113414502borating
crating103725202_crating
curating11314292curating
derating103222282derating
dilating102714902dilating
disrating11714552disrating
epilating12310962epilating
fixating1936182fixating
girting93113332gir_ting
grating93923182_grating
gyrating1337452gyrating
librating1239052librating
ligating102212282ligating
migrating13910532migrating
misrating121014852misrating
nidating1039782nidating
nitrating10312672nitrating
operating12313722operating
opiating11410092opi_ating
orating83520322_orating
parading12313862parading
parawing14310582parawing
parting103527382par_ting
phrasing1438012phrasing
picoting1338882picoting
piloting1139692piloting
piratic11314292pirati_c
pitting103618872pi_tting
pivoting1436182pivoting
plating103823072p_lating
pleating112916052pleating
porting103021782por_ting
praying133717322p_raying
printing113216082printing
prorating12314282prorating
pupating1337682pupating
rating74938702__rating
spiraling1237952spiraling
spiriting1238412spiriting
spirting112913632spir_ting
titrating10310112titrating
uprating11311112uprating
vibrating1537472vibrating
abating10413973_abating
ablating11311993ablating
abrading1239503abrading
acierating1348313acierating
agitating1138853agitating
airing74927503air__ing
airthing12297953airthing
animating12312503animating
arraying1238753arraying
asperating1349563asperating
aviating12311013aviating
bating95132253__bating
beating104326873_beating
beraking153612973beraking
biasing103512453bi_asing
bighting15269453bighting
birching16328463birching
birding114014923bir_ding
birling104317053bir_ling
birring103713063bir_ring
birthing14338433birthing
biting95321823bi__ting
bitting103717293bi_tting
bleating113514503bleating
bloating113512813bloating
boating103721303_boating
bracing123817613_bracing
braking143917713_braking
braving133714613_braving
braying134416313_braying
brazing193715113_brazing
bruting102612993_bruting
bursting1138703bursting
carting104228283car_ting
ceratin93020163ceratin_
ceratins102818733ceratins
charting142614193charting
cheating144014523cheating
circling1338423circling
citing94220183ci__ting
cleating113518133cleating
coating103525313_coating
crafting143710173_crafting
craning103620303_craning
craping124018713_craping
craving134015733_craving
crazing193914583_crazing
creating113921953creating
darting94020663dar_ting
dating85326483__dating
debating123213733debating
delating103119603delating
depilating1439183depilating
depurating1438643depurating
deratting1139513deratting
dialing94318173di_aling
dictating1338883dictating
dieting93616833di_eting
dighting142510843dighting
diluting10248983diluting
dinting93520553di_nting
directing1338813directing
dirking133812603dir_king
dirling93316073dir_ling
dirtying1336093dirtying
doating93816863_doating
donating10311803donating
drafting13339403_drafting
draping114213353_draping
dratting10389653_dratting
drawing123812053_drawing
draying123813843_draying
drifting13338733drifting
eating75134403__eating
elating83423083_elating
emigrating1467503emigrating
enraging1049573enraging
equating18310113equating
erasing8317963_erasing
estating92614993estating
expiating1938543expi_ating
farting114120753far_ting
fating105328673__fating
fighting162710083fighting
fileting1239303fileting
filiating1339243filiating
filtrating1445973filtrating
firing104021723fir__ing
firming132811223fir_ming
firstling1334423firstling
fisting113818123fi_sting
fitting113516563fi_tting
flirting12319013flir_ting
floating123111883floating
foraging1358063foraging
foraying1537433foraying
framing133014793_framing
fraying143413433_fraying
fritting123510703fritting
furcating1537783furcating
garaging1139043garaging
garoting10510703garoting
gating84826953__gating
gelating103015733gelating
gifting123810893gi_fting
girding103611883gir_ding
girdling1146823girdling
girning93210693gir_ning
girthing13256083girthing
gitting93215703gi_tting
gloating102611463gloating
gracing113216443_gracing
grading103918713_grading
grafting13319623_grafting
granting103514523_granting
gratin74520583_gratin_
gratine84719193_gratine
gratings103910763_gratings
gratins84119183_gratins
graving123114563_graving
graying124115883_graying
grazing183514553_grazing
grifting13299263grifting
gritting10309983gritting
hating104929713__hating
hearting12513123hearting
heating114024323_heating
highting16259723highting
hilting113316893hi_lting
hinting113919223hi_nting
hireling121210993hireling
hiring104421603hir__ing
hirpling1467223hirpling
hirsling1277543hirsling
histing113720373hi_sting
hitting113017273hi_tting
hurting113914033hur_ting
hydrating1746323hydrating
ideating10311703ideating
imaging1138083_imaging
imitating1238763imitating
iodating1038823iodating
iring66025423_ir__ing
irising83614423_irising
irking114611753_ir_king
ironing82414013_ironing
isatin6412213_isatin_
isatine7311763_isatine
isatins7310773_isatins
iterating10314253iterating
jilting153211743ji_lting
karting123716063kar_ting
keratin113314153keratin_
keratins122313483keratins
kilting123213853ki_lting
kirning12319333kir_ning
kiting114117093ki__ting
kitting123214443ki_tting
lapidating1445233lapidating
lariating10311783lariating
legating102313113legating
liberating1349253liberating
lichting14268513lichting
lifting113313273li_fting
lighting132811833lighting
lilting83515383li_lting
limiting1138813limiting
linting83820983li_nting
liquating1946313liquating
listing84020593li_sting
locating11311503locating
luxating1645613luxating
marting103325013mar_ting
mating94832913__mating
meriting11314683meriting
milting103619123mi_lting
minting103020813mi_nting
minuting1139723minuting
miring93723803mir__ing
misacting1439083misacting
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misting103623383mi_sting
moating104218153_moating
mutating112211753mutating
narrating10310353narrating
negating102012833negating
nictating1237573nictating
notating92513343notating
nutating92411953nutating
oppilating1544853oppilating
outrating10916403outrating
oxidating1845053oxidating
pacing114522753p__acing
paginating1447523paginating
paging104020403p__aging
painting113614423painting
pairing103716733pair__ing
palatine10316063palatine
paling93530133p__aling
palpating1438533palpating
panting104025423p_anting
parang93715513para__ng
parasang1147333parasang
parawings1535823parawings
parbaking1877203parbaking
parching164313053parching
parenting12611583parenting
pargeting1338283pargeting
parging113318603par_ging
paring94236493p__aring
parking143423043par_king
parlaying1537303parlaying
parling103823763par_ling
paroling113316213paroling
parring103222063par_ring
parroting1239153parroting
parrying14168133parrying
parsing103819553par_sing
partaking1698673partaking
partings113513733par_tings
partying14168893partying
pasting103826553p_asting
patin76832853p__atin_
patina86022193p__atina
patinating1339873patinating
patine85328123p__atine
patins87528783p__atins
patriating13510203patriating
patting103722343p_atting
paving124519743p__aving
pawing124519553p__awing
paying123722163p__aying
peacing124117073p_eacing
peaking144317693p_eaking
pealing104123203p_ealing
pearling11912013pearling
pedaling122412133pedaling
pelting102917273p_elting
perching163711633perching
periling11316863periling
perking143716463per_king
permeating1539923permeating
perming123416093per_ming
permuting1446553permuting
perorating13313133perorating
pertain92714963pertain_
pertains102113423pertains
perusing11811063perusing
pervading1636303pervading
petting103720953p_etting
pharming16248143pharming
phasing133211673p_hasing
phonating1537813phonating
phrasings1544333phrasings
phreaking1936473phreaking
piaffing1733923piaffing
pickaxing2543103pickaxing
picketing1835683picketing
picking163418333pi_cking
pickling17239203pickling
piddling13208953piddling
piecing12410453pi_ecing
pieing93917653pi__eing
piercing1346663piercing
piffling1745133piffling
pigging123614673pi_gging
piing85218833pi___ing
piking133719643pi__king
piling95025593pi__ling
pillaging1345553pillaging
pillaring1237643pillaring
pilling103722563pi_lling
pilotings1234353pilotings
pimping143812123pi_mping
pinang92611593pina__ng
pinching163711053pinching
pindling122110983pindling
pinging113419553pi_nging
pining93726533pi__ning
pinking143918943pi_nking
pinning103417853pi_nning
pipetting1435513pipetting
piping114017453pi__ping
pipping113414743pi_pping
piquing1935873pi_quing
piracies12312643piracies
pirana8713263pira__na
pirate82322883pirat__e
pirated102515613pirat_ed
pirates93020333pirat_es
piratical1348653piratical
pishing134314373pi_shing
pissing103914803pi_ssing
pitching163411113pitching
pithing134014053pi_thing
pittings11349123pi_ttings
pitying132910243pi_tying
placating1438513placating
placing123815283p_lacing
plaiting113113513plaiting
planing103418253p_laning
planting113515383planting
platina94413643p_latina
platings113611363p_latings
platting114813033platting
playing133816093p_laying
pleading123011443pleading
pleasing112611593pleasing
plighting1635563plighting
plotting113011013plotting
pointing112813683pointing
pomading1437423pomading
poring94227273por__ing
porking143515813por_king
portaging1346843portaging
positing11312303positing
posting105622243p_osting
potting103720893p_otting
pouting103519943p_outing
praising113214563p_raising
praline93019743p_raline
prancing132612163p_rancing
prang84820323p_ra__ng
pranging123012723p_ranging
pranking153813383p_ranking
pratingly1538363p_ratingly
prattling1246303p_rattling
prawning1446963p_rawning
preacting142412533preacting
predating13514653predating
preeing103817673p_reeing
preying133114553p_reying
pricing123417343p_ricing
pricking173212603pricking
priding113317543p_riding
priesting1239483priesting
prigging13299093prigging
prilling113413413prilling
priming123417373p_riming
primming15268173primming
primping15338893primping
prinking153212453prinking
printings12268103printings
prising103321453p_rising
prissing113011453prissing
pristine10313503pristine
prizing193514683p_rizing
probating14311183probating
probing123314443p_robing
pronating12313763pronating
prosing103319383p_rosing
proving134214073p_roving
pruning10311733p_runing
prying124114803p_r_ying
pshawing1733523pshawing
pulsating1236343pulsating
punting103318443p_unting
pureeing1137273pureeing
purfling1467763purfling
purging113314183pur_ging
purling103620293pur_ling
purpling1368543purpling
purring104515823pur_ring
pursing103715553pur_sing
pursuing1146233pursuing
putting103218573p_utting
quirting18238383quir_ting
racing95030533__racing
rafting113815753__rafting
raging85126433__raging
raking114728423__raking
ranting84025413__ranting
raping94829853__raping
raring74332873__raring
rasing74330833__rasing
ratine65131823__ratine
ratings84217413__ratings
ratting83822363__ratting
raving105128853__raving
raxing144321023__raxing
raying105027193__raying
razing164524543__razing
rebating112418343rebating
recrating121318793recrating
redating102620173redating
regrating111316213regrating
relating92725443relating
remating112322413remating
rifting113515003ri_fting
righting132610853righting
rioting82716393ri_oting
rivaling1239913rivaling
riveting12139443riveting
rotating92614553rotating
ruinating1039593ruinating
sating74735453__sating
scarting113415263scarting
scraping133310863scraping
seating84130683_seating
sedating103014113sedating
separating1348643separating
seriating10916403seriating
serrating10513203serrating
shirting123213613shir_ting
sifting113014593si_fting
sighting133110863sighting
silting83320483si_lting
sinuating1039683sinuating
siring75128313sir__ing
siruping1136503siruping
siting74126623si__ting
sitting83519633si_tting
situating1038883situating
skating123613853_skating
skirting13289393skir_ting
slating83724653_slating
smarting113212453smarting
solating9315593solating
sorting83221813sor_ting
spiralling1343963spiralling
spiring103918183spir__ing
spiting103917623spi__ting
spitting113012323spi_tting
sporting112415463spor_ting
spraying14299883spraying
sprinting12310033sprinting
spurting113111633spur_ting
starting93116173starting
stating83725163_stating
strafing122111193strafing
strawing122411623strawing
straying122912693straying
striating10914193striating
supinating1357833supinating
sweating123213023sweating
tarting84222653tar_ting
thirsting1335283thirsting
thrawing1535963thrawing
threating131010043threating
throating1398393throating
tilting83417103ti_lting
tincting1148883tincting
tinting84620603ti_nting
tiring74023093tir__ing
tirling83315733tir_ling
tracing103720153_tracing
trading93517973_trading
treating92519613treating
triaging102610543triaging
uncrating12813183uncrating
updarting1334333updarting
updating1236593updating
upgrading1444903upgrading
urinating10310653urinating
vacating14310353vacating
variating13310943variating
vialing113614163vi_aling
violating1337433violating
visaing11279333visa_ing
visiting1238393visiting
vitiating1338403vitiating
wilting113515913wi_lting
wiring104521023wir__ing
wisting113519743wi_sting
witing103522823wi__ting
witting113417063wi_tting
worsting1267683worsting
wrathing15248923_wrathing
writing113713893_writing
yirring11307763yir_ring

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 Limit1461625217.03320782.3
3Display Results5215210.2032566.5
 (SQL Overall)1786915217.39224173.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.