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

539 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
speired10381110(None) 
speared104314421speared
speered103614811speered
speiled104412121speiled
spiered104412461spiered
spired94921861sp_ired
aspired1068172asp_ired
heired103813042_heired
paired95017522_paired
peered93819492_peered
peined94918842_peined
peised94817682_peised
seared75232842s_eared
seined74023062s_eined
seised74218122s_eised
seized164313652s_eized
sered65737292s_e_red
sheared114516012sheared
sheered113515462sheered
sired66134282s__ired
skeined1236772skeined
smeared104510622smeared
sneered83113972sneered
spared95427492sp_ared
sparred104512862sparred
speaned103411522speaned
spearer93913662spearer
specced14266702specced
specked16329012specked
speed85526622spe__ed
speeded113310422speeded
speeled103712452speeled
speir75315362speir__
speirs85013232speir_s
speise84614252speise_
speises93813932speises
spelled103714742spelled
spewed125512332spe_wed
sphered133512312sphered
spiced115218312sp_iced
spied85427712sp_i_ed
spieled104811882spieled
spiked134915552sp_iked
spiled94621992sp_iled
spined95423942sp_ined
spire75828692sp_ire_
spirea84015632sp_irea
spirem104214162sp_irem
spires84628112sp_ires
spirted103913072sp_irted
spited94820442sp_ited
spliced124310592spliced
splined105013112splined
spoiled104811352spoiled
spoored104411292spoored
spored94821792sp_ored
spurred103610622spurred
squired173710062squired
steered83615252steered
supered10316122supe_red
admired1135703admired
aeried74221873_aeried
afeared1176833afeared
aired66032923__aired
aneared8512743aneared
antired82316193antired
aperies9423203aperies
appeared1336143appeared
aspersed11428303aspersed
aspire8612123asp_ire_
aspirer967903asp_irer
aspires9612043asp_ires
attired8238913attired
averred11237593averred
bemired123410633bemired
bleared104211253bleared
capered123014043cape_red
ceiled94114953_ceiled
cered85227443_ce_red
chaired134211243chaired
cheered133713303cheered
choired13349343choired
cleared103612463cleared
deaired9411533deaired
deiced104214483_deiced
desired9311983desired
despaired1344503despaired
eared65139503__eared
epeiric1145313epeiric
erred65915673__erred
espied9359783esp_i_ed
esquired18315083esquired
expired1736403expired
faired105915773_faired
feared106320433_feared
fired94829743__fired
fleered11309503fleered
geared85317743_geared
glaired9387753glaired
haired105117173_haired
heiled104415613_heiled
hired95226263__hired
impaired1335143impaired
inspired1136273insp_ired
ired55131873___ired
jeered143912793_jeered
laired75216813_laired
leered73816223_leered
metred95315143_metred
mired85729223__mired
neared75119813_neared
opened94311863ope_ned
opined95113853op_ined
osiered837123osie_red
overed102216623ove_red
paiked135113433_paiked
pained95622853_pained
papered122513173pape_red
pared86946763_p_ared
parred95024073_parred
peaced115818913_peaced
peaked136117403_peaked
pealed95322813_pealed
pearled10411553_pearled
peched144915343_peched
pecked155019103_pecked
peed76239183_pe__ed
peeked134314583_peeked
peeled94119713_peeled
peened94318163_peened
peeped113915393_peeped
peeved124112893_peeved
pegged114811913_pegged
peise75825773_peise_
peises84125043_peises
pelted94617763_pelted
pended103819013_pended
penned94217613_penned
pepped103113403_pepped
pere66450263_pe_re_
perea75026443_pe_rea
peres76246643_pe_res
periled10316323_periled
period9314983_period
perked134617693_perked
permed115217353_permed
petered103314973_petered
petrel83111533_petrel
petted94121523_petted
pieced113912103_pieced
pied75035373_p_i_ed
pierced12347593_pierced
piked125623313_p_iked
piled85232993_p_iled
pined85935323_p_ined
piped105123163_p_iped
plied85118593_pli_ed
poised94918473_poised
pored85234513_p_ored
poured95116743_poured
prefired144310753prefired
prewired14358473prewired
priced115018883_priced
prided103618033_prided
pried84426863_pri_ed
primed115118913_primed
prised94322203_prised
prized184415393_prized
purred94218073_purred
queered17117223queered
queried1738693queried
quired163711953_quired
rapiered1136053rapiered
reared75930013_reared
rebred95816353_rebred
refired115116993refired
rehired115013153rehired
reined74425523_reined
reived104518133_reived
repaired1148953repaired
repined104918773repined
respired1148993resp_ired
retired84620143retired
rewired115413283rewired
sabered103213023sabered
sabred95916533s_abred
sacred94917103s_acred
sailed74327763s_ailed
sained75424243s_ained
satire63218003satire_
satires72617573satires
savored1158343savored
scared95227293s_cared
scarred104512633scarred
scended11329873scended
scented102811893scented
sceptred1343663sceptred
scored94621133s_cored
scoured103811153scoured
scribed124510643scribed
scried95817313scri_ed
scrived134511113scrived
seabed95017693s_eabed
sealed74328363s_ealed
seamed94823883s_eamed
searer65432023s_earer
seated75131063s_eated
secret8325063s_ecret
secured1059723secured
seed55549483s_e__ed
seedbed11246613seedbed
seeded84520463s_eeded
seeled73922093s_eeled
seemed95117613s_eemed
seeped94317523s_eeped
seethed113410193seethed
segued838513s_egued
seidel7311083s_eidel
seine55732873s_eine_
seiner64622483s_einer
seines65029903s_eines
seise54727853s_eise_
seiser65318343s_eiser
seises64026713s_eises
seize143819503s_eize_
seizer154114573s_eizer
seizes154317533s_eizes
selfed10310913s_elfed
sended85121233s_ended
sensed73918163s_ensed
sepaled10510593sepaled
sere46153473s_e_re_
serer55935513s_e_rer
seres55448893s_e_res
serged84118773s_erged
series64540973s_eries
serifed11811463serifed
serried82513973s_erried
served104616813s_erved
severed113513863severed
sewed95325163s_e_wed
sewered112911243sewered
sexed136618543s_e_xed
shaird10288703shair_d
shared105829063s_hared
sheafed14388973sheafed
shearer104414693shearer
sheaved143411633sheaved
shedded13419063shedded
sheened113511703sheened
sheerer103813853sheerer
sheeted113813043sheeted
shelled113815093shelled
shelved14379933shelved
sherd96321153she_r_d
shewed134716183she_wed
shied96125493s_hi_ed
shined104620783s_hined
shire84727133s_hire_
shires95225573s_hires
shirked153710463s_hirked
shirred113710503shirred
shored105723653s_hored
shred98125613s__hred
shrined114112413shrined
shrived144712183shrived
sided74825963s__ided
sieged85212713sie_ged
sieved104611443sie_ved
simpered1338253simpe_red
siped84927683s__iped
sire46150423s__ire_
siree55238813s__iree
siren54525823s__iren
sires55945373s__ires
sited65130743s__ited
sized155519243s__ized
skeed105018983ske__ed
skelped1435203skelped
skewed145610233ske_wed
skewered1634213skewered
skied104417763s_ki_ed
skirled12348183s_kirled
skirred12347083skirred
skirted12388613s_kirted
skited114313483s_kited
skived14429893s_kived
sleaved113611133sleaved
sledded10378873sledded
sledged103610333sledged
sleeked123510883sleeked
sleeted83113223sleeted
sleeved11419913sleeved
sleighed1334033sleighed
slewed104815523sle_wed
sliced94416313s_liced
slimed94915123s_limed
sliped95417063s_liped
sluiced1046053sluiced
slurred8359193slurred
smearer94110403smearer
smeeked14287223smeeked
smelled103511863smelled
smelted10399093smelted
smerked14327283smerked
smiled93716433s_miled
smirked14307233s_mirked
snailed83811923snailed
snared74824553s_nared
sneaked12329693sneaked
sneaped10338813sneaped
snedded10377393snedded
sneerer73512313sneerer
sneezed17287793sneezed
snelled83313053snelled
sniped94913483s_niped
snored74819543s_nored
soared74324293s_oared
sobered102912433sobered
soiled73822473s_oiled
soiree62919483s_oiree
sopited104211063sopited
sored66141783s__ored
soured74921863s_oured
spaced114517253sp_aced
spaded103816753sp_aded
spaed85522273sp__aed
spalled103113133spalled
spammed14348523spammed
spanked143111733spanked
spanned104111223spanned
spare75135563sp_are_
sparer84524963sp_arer
spares84834553sp_ares
sparged113512763sparged
sparid94016933sp_arid
sparked143513143sparked
spasmed12296993spasmed
spathed134013183spathed
spatted104014143spatted
spavined1434333spavined
spawned13316803spawned
spayed124213613sp_ayed
speaker133311213speaker
spear75821063spear__
spearers103711143spearers
spearhead1542983spearhead
spearmen1234853spearmen
spears84019473spear_s
speciated14207543speciated
specie10412223specie_
species11314133species
specified1746253specified
specimen1444423specimen
speckled17255833speckled
specter113111733specter
spectre11297773spectre_
spectres12268683spectres
sped76031493sp___ed
speeder103811073speeder
speedo94011993spe__edo
speedread1342383speedread
speeds94316053spe__eds
speedy1218410793spe__edy
speel74420763spe__el
speer74623903spe__er
speers85019953speer_s
speil75618643spei__l
speils84116223spei_ls
speiring113711263speiring
speiss84311643spei_ss
speisses10245693speisses
speller95415153speller
spelter94113703spelter
spence103813793spence_
spencer113610973spencer
spences113413923spences
spend85619333spe__nd
spender103713693spender
spense83912433spense_
spenses92913573spenses
sperm93216023spe_r_m
sperms102512603spe_rms
spewer115112153spe_wer
spewers124210663spewers
sphere113313663sphere_
spheres123114353spheres
spherier1337783spherier
spice95528813sp_ice_
spicer104719313sp_icer
spices104326033sp_ices
spicey134414233sp_icey
spider94516803sp_ider
spiegel1034553spiegel
spiel74623913sp_i_el
spieler93111233spieler
spier75728033sp_i_er
spiers84421743spier_s
spies76037623sp_i_es
spiffed16257103spiffed
spike114922843sp_ike_
spiker124315663sp_iker
spikes124520713sp_ikes
spikey155411333sp_ikey
spile75230083sp_ile_
spiles84227913sp_iles
spilled103613623spilled
spine76534423sp_ine_
spinel85317333sp_inel
spines85132033sp_ines
spinet85629753sp_inet
spiraea9407983sp_iraea
spiral83715343sp_iral
spiraled1137733sp_iraled
spireas94412513sp_ireas
spireme11478363sp_ireme
spirems11499563sp_irems
spirier93214073sp_irier
spirit83519923sp_irit
spirited1148973spirited
spiroid10219823sp_iroid
spirt75032953sp_ir_t
spirts85317133sp_irts
spiry105017353sp_ir_y
spite75430663sp_ite_
spites84127333sp_ites
spitted103912703spitted
splayed13357813splayed
splice104915103splice_
splicer114710523splicer
splices113914383splices
spline86020533spline_
splines94718893splines
splinted11369253splinted
splore81611303splore_
splores91910953splores
splurged1243923splurged
spoiler93310683spoiler
spoked134413893sp_oked
sponged1137953sponged
spoofed13399103spoofed
spooked144510473spooked
spooled104613523spooled
spooned103412443spooned
spore75428593sp_ore_
spores84726613sp_ores
sported104015433sported
spotted103713143spotted
spoused10349653spoused
spouted103412263spouted
sprained1138433sprained
sprayed13398903sprayed
spread9312533sp__read
spree74830863sp__ree
sprier84119063spri_er
sprigged13316223sprigged
springed123911323springed
sprinted113411163sprinted
sprite84421773sprite_
sprites94220333sprites
spritzed2044803spritzed
spruced12307533spruced
spudded12235903spudded
spued84918473sp__ued
spumed114711543sp_umed
spunked14307783spunked
spurned10339263spurned
spurrer93710223spurrer
spurrey12307813spurrey
spurted103111973spurted
squared173610563squared
squire155912463squire_
squires163812843squires
squirmed2034173squirmed
squirted1845793squirted
stained84215343stained
stared75429873s_tared
starred85013453starred
steaded92811673steaded
steamed103712143steamed
steed66024943ste__ed
steeked124010473steeked
steeled83513223steeled
steeped103412283steeped
steerer73113633steerer
steeved113610133steeved
stemmed12278153stemmed
stepped123210053stepped
stere55328543ste_re_
stereo65317913ste_reo
steres63929533ste_res
stetted82610403stetted
stewed104814243ste_wed
stied65723033s_ti_ed
stiped94517073s_tiped
stirred8359703stirred
stored75524213s_tored
storied8515163storied
striped105214363striped
strived114713663strived
sueded84014633sue_ded
sugared938583sugared
suited74019423s_uited
suspired1135613suspired
sutured8310373sutured
swearer10349953swearer
sweated113411543sweated
swelled113211703swelled
swerved1455703swerved
swiped123811093s_wiped
swirled11308223s_wirled
swived133610633s_wived
syphered1755013syphered
tapered102612933tape_red
teared75722153_teared
tiered73613973tie_red
tired65228903__tired
umpired1235783umpired
unaired82916013unaired
unfired112212453unfired
unhired112512153unhired
unpaired11208943unpaired
untired82316383untired
updived1434093updived
updried11226473updried
upended11267323upended
upgird10103933upgir_d
upgirded1342333upgirded
uppiled12216593uppiled
upreared1137083upreared
upsized19246253upsized
ushered1139153ushe_red
veered103612743_veered
veiled103714543_veiled
veined104413913_veined
waired106015833_waired
weird95111283_weir_d
weirded1234513_weirded
wired95327643__wired

Search took 7 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.420425454.8
2DLD Change Limit1340275396.28021341.9
3Display Results5395390.1902836.8
 (SQL Overall)1786915396.89025934.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.