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

229 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
parotid10291551(None) 
carotid102014831carotid
parotic112518041parotic
parotids112610411parotids
parotoid11410031parotoid
aprotic112715242aprotic
aroid65428342_aro_id
carotids11229942carotids
carotin92216732carotin
garoted9710132garoted
paretic113016672paretic
parodic122311722parodic
parodied1238332parodied
paroled104217632paroled
parotoids1256952parotoids
parroted1158842parroted
parted94228682par_ted
partied103516552par_tied
peroxid17310272peroxid
proteid103513672p_roteid
sparoid102311542sparo_id
acaroid103512313acaro_id
acrotic112515543acrotic
aortic8316613_aortic
aphotic142913123aphotic
aproned10311503aproned
aramid93315613_aramid
arctic10313513_arctic
argotic10310283_argotic
arid57642713_ar__id
aroids75118223_aro_ids
around72712413_around
avoid95516683_avo_id
azoted16388593_azoted
azotic172711633_azotic
barmaid1238203barmaid
barytic1437823barytic
bromid112612893_bromid
cactoid12311033cactoid
carabid12311333carabid
caroled103717693caroled
caroli85918233caroli_
caromed123713623caromed
carotidal1245133carotidal
carotins102315583carotins
carrotin102210893carrotin
carted98631443car_ted
caryatid1447953caryatid
caryotin13268353caryotin
cerotic11415063cerotic
darted84620923dar_ted
droid74218543_dro_id
erotic82620273_erotic
factoid1338693factoid
fagoted1236073fagoted
farted105121783far_ted
gadoid9310463gado_id
ganoid8314443gano_id
garote7717953garot_e
garotes8614563garotes
garoting10510703garoting
garotte868703garotte
garotted1066193garotted
garroted1056783garroted
haloid104317763halo_id
karstic1357983karstic
karyotin15194833karyotin
labroid1038823labro_id
maloti8313213maloti_
mantid93820383ma_ntid
marted94425213mar_ted
martin84122523mar_tin
mastoid10711233mastoid
mattoid1079283mattoid
narcotic1277913narcotic
ootid61416703__ootid
padroni10278613padroni_
pagod95013683pago__d
pagurid11105443pagurid
paid75737483pa___id
painted104214633painted
pallid93915283pa_llid
panoptic1447183panoptic
panted95024823pa_nted
pantie84326473pa_ntie
paraded114014263paraded
paranoid11311143paranoid
parboil1138323parboil
parched154013693parched
pard76441323par___d
pardi85723953par_di_
pardie96021443par_die
pardoned12189333pardoned
pared86946763par__ed
parented11912213parented
paresis93315093paresis
paretics122312443paretics
parfait12312053parfait
parged104922043par_ged
pargeted1238683pargeted
paris75145943par__is
parities10522973parities
parity114719873parit_y
parked134425143par_ked
parled94626293par_led
parodies11313693parodies
parodist11412763parodist
parodoi10267723parodoi
parodos103011753parodos
parody12410093paro_dy
parol74826273paro__l
parole84425253paro_le
parolee94119643parolee
paroles95025883paroles
paroling113316213paroling
parols84722613paro_ls
paronym1437503paronym
parosmia1245953parosmia
parotitic1349333parotitic
parotitis1149173parotitis
parous84024163paro_us
parred95024073par_red
parried103615723parried
parrot8320663parrot__
parroter1058203parroter
parroting1239153parroting
parrots9312743parrot_s
parroty1247863parrot_y
parsed96323893par_sed
parslied1137823parslied
parsnip1146323parsnip
parsonic1239703parsonic
part65967463par_t__
partan83820563par_tan
partial92616263par_tial
partier93520713par_tier
parties93230863par_ties
parting103527383par_ting
partita9310863par_tita
partite9317133par_tite
partly116315473par_tly
parton84720993par_ton
partons94620513partons
partook1337313partook
parts77743373par_t_s
party106630613par_t_y
parvis116114803par_vis
parvolin1376933parvolin
pasted94426903pa_sted
pastie85525523pa_stie
pastil85018323pa_stil
pastis84924323pa_stis
pated85237843pa__ted
patin76832853pa__tin
patio74426353pa__tio
patois84319363pato_is
patootie1046303patootie
patriotic13107583patriotic
patted94724683pa_tted
pattie84020963pa_ttie
pavid115717003pa__vid
peptid112712373p_eptid
peracid12312993peracid
percoid12312313percoid
periodid1248163periodid
periotic12313443periotic
periti8319953periti_
peroxide1848183peroxide
peroxids1837453peroxids
phoronid1449073phoronid
photic133316443p_hotic
phytoid1678753phytoid
picoted1239213picoted
piloted10310323piloted
pirated102515613pirated
piratic11314293piratic
pirogi9299013pirogi_
pivoted1336513pivoted
placoid1239773placo_id
plastid102112523plastid
ported94223243por_ted
practic13312253practic
prated94924923p_rated
prebid113512843p_rebid
probed114114823p_robed
probit103218353p_robit
prod76129503p_ro__d
profit113016273p_rofit
prolix1538683p_rolix
prosed94921093p_rosed
prosit85124593p_rosit
prostie91617743p_rostie
protea82214763p_rotea
protei82615313p_rotei
proteide11239723p_roteide
proteids11259943p_roteids
protein92414733p_rotein
protend104012793p_rotend
protist9320223p_rotist
protium11312293p_rotium
proton84318893p_roton
protoxid1849143p_rotoxid
protyl11308213p_rotyl
proud84615483p_ro_ud
proved125016033p_roved
provide1339853p_rovide
psocid1137253p_socid
ptotic102713373p_totic
pyoid11513763p_yo_id
pyralid1347983pyralid
pyramid1547513pyramid
pyretic143210783pyretic
pyritic143311313pyritic
pyrosis12411653pyrosis
roti46332933__roti_
rotis56327063__rotis
sarcoid10310453sarcoid
sarod65325873saro__d
sparid94016933spar__id
sparoids11218713sparo_ids
spiroid10219823spiro_id
sporoid102310733sporo_id
tarot55943933tarot__
tarots66422993tarot_s
tarted74923373tar_ted
toroid7416013toro_id
viroid10411523viro_id
warted104223233war_ted
xerotic16410863xerotic

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 Limit1340272297.00319138.5
3Display Results2292290.0763013.2
 (SQL Overall)1786912297.46923924.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.