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

343 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
psyops133434(None) 
estops84011222estops
payors114312642payors
plops95920332p_lops
poops94422412p_oops
pops86340952p__ops
postops11311712postops
poyous112911622poyous
preops104911942preops
props95726882p_rops
psoas75012982ps_oas
psychs1653652psychs
scops95820192_scops
shops104222902_shops
slops75026012_slops
sops65244562_s_ops
stops74827282_stops
swops105913972_swops
sysops1136012_sysops
anyons94513503anyons
ascots85312513ascots
askos95011773asko_s
aslope839013aslope
asps65622093as__ps
bayous11411153bayous
bebops1237623bebops
bishops1437033bishops
bloops106611343bloops
bops86037983__bops
boyos105418283boyo_s
chops125019873_chops
clops95924853_clops
coops96229643_coops
cops86751373__cops
crops96125233_crops
droops95110963droops
drops85719503_drops
escots84211743escots
estop74312103estop_
flops105920143_flops
fops96532683__fops
galops94712623galops
glops85619553_glops
goops86620963_goops
guyots1036003guyots
gyps105115023_gy_ps
hoops105621073_hoops
hops97942633__hops
hypos1312014743_hypos
hyps125418413_hy_ps
hysons1237633hysons
hyssops1543123hyssops
jalops15329593jalops
joyous16276763joyous
joypops2162603joypops
kayoes134710823kayoes
kayos127714703kayo_s
knops115911813_knops
kops107031293__kops
layups1133993layups
loops75723963_loops
lops66043353__lops
mayors115714193mayors
mayos105521933mayo_s
maypops16104453maypops
mops85940133__mops
myope124010973_myope
myopes13419963_myopes
myopy15457353_myopy
netops839213netops
oops65232673__oops
ops56641253___ops
orlops847303orlops
osmols8137313osmols
osmous8138183osmous
paeons83915523paeons
pagods105310193pagods
palps94719563p_alps
paps86443453p__aps
parols84722613parols
parous84024163parous
paseos88015813paseo_s
pastors94119003pastors
patois84319363patois
payees114812903payees
payers114621823payers
payoff1736023payoff
payoffs1843243payoffs
payola11208113payola
payolas12148973payolas
payor105413843payo_r
payout11714653payout
payouts1247303payouts
pays95940223pay__s
peeps95822363p_eeps
pekoes124410423pekoes
peons75327183p_eons
pepos96620083pepo_s
peps85134513p__eps
perps95521483p_erps
pesos77221623peso_s
pestos84719083pesto_s
peyote1139853peyote
peyotes1238483peyotes
peyotl1146233peyotl
peyotls1233633peyotls
phons105221143p_hons
phots105418503p_hots
physes14399783physes
physis14359663physis
phytols15276553phytols
phytons15319063phytons
picots104616443picots
pilots84018873pilots
pilous84717753pilous
pimps114616983p_imps
pinons86019943pinons
pinots85920273pinots
pinups1037413pinups
pinyons12299003pinyons
pions75826393p_ions
pious74621273p_ious
pips85837133p__ips
piscos105112593pisco_s
pisos76021063piso_s
pistols93213983pistols
pistons93016373pistons
pistous92714383pistous
pitons85319043pitons
pivots115111903pivots
pleons84213343pleons
plods85719293p_lods
plop86625743p_lop_
plots75025673p_lots
plows105419903p_lows
ploys105816593p_loys
plumps124612613plumps
plyers114912983plyers
poboys1397313poboys
pods76540153p__ods
pois66539043p__ois
polos76129913polo_s
pols66044563p__ols
polyols1238493polyols
polyps13479763polyps
pomos95321583pomo_s
pomps115316193p_omps
poms87037743p__oms
pons65850603p__ons
poods85124753p_oods
poofs105222793p_oofs
poohs103915713p_oohs
pools74427703p_ools
poons75430973p_oons
poop86532813p_oop_
poos65949113p__oos
pop76252253p__op_
pope85535613p__ope
popes95933813p__opes
popsy125713403p__opsy
porous84419483porous
postop10511943postop_
pots66452363p__ots
pows95537663p__ows
poyou102611523poyo_u
praos74923563prao_s
preop94715873preop_
preps96220693p_reps
primps124711823primps
prions84317783prions
priors83914483priors
proas75028803p_roas
prods85523553p_rods
profs105120893p_rofs
progs86624153p_rogs
proms95426413p_roms
proofs114511683proofs
prop85932813p_rop_
pros65742783p_ro_s
pross76529403p_ross
prows106327013p_rows
pryers115012243pryers
psalms1045673psalms
pseuds944793pseuds
pshaws14435703pshaws
psis68120343ps__is
psoae74411623ps_oae
psoai7469923ps_oai
psych1554963psy_ch
psyche1674293psyche
psyches1755803psyches
psycho1674533psycho
psychos1765263psychos
psylla1133953psylla
psyllas1244883psyllas
psywar1443323psywar
psywars1533673psywars
pulps95116483p_ulps
pumps115520603p_umps
pups86032233p__ups
pushups1433653pushups
putons83515153putons
pyas96225703p_y_as
pyes95528993p_y_es
pyins105815863p_yins
pylons113011243pylons
pyoid11513763p_yoid
pyoses114314303p_yoses
pyosis114012123p_yosis
pyres105523883p_yres
pyrope132810533pyrope
pyropes142210193pyropes
pyros105718293p_yros
pyxes175911403p_yxes
pyxis17458633p_yxis
rayons94113343rayons
rebops10311433rebops
ripstops1265013ripstops
ryots85313783_ryots
salps74423243_salps
samps96124673_samps
saps65346373_s_aps
scoops105414363scoops
scop85925523_scop_
scope94821483_scope
scopes104719593_scopes
scots74025913_scots
scows106617803_scows
scups95316653_scups
seeps74828753_seeps
ships105123773_ships
shoes85429663_shoes
shogs95319713_shogs
shoos84226363_shoos
shop95629843_shop_
shots84730853_shots
shows115324583_shows
simps94719763_simps
sips65740103_s_ips
skeps115614253_skeps
skips115616603_skips
slaps76025713_slaps
slips76023723_slips
slobs74419873_slobs
sloes54728873_sloes
slogs64521843_slogs
sloops85513623sloops
slop66533873_slop_
slope75823563_slope
slopes84820453_slopes
slots54830533_slots
slows85323463_slows
smogs85112163_smogs
snaps74719563_snaps
snips75818013_snips
snobs74716153_snobs
snogs66017493_snogs
snoops84314173snoops
snots55225123_snots
snows84719893_snows
soaps75120713_soaps
sobs64941753_s_obs
sods54940213_s_ods
sols45448163_s_ols
soms66239373_s_oms
sons46049553_s_ons
sooks94425453_sooks
soots55536213_soots
sop57557863_s_op_
soph97024203_s_oph
sophs104916023_s_ophs
sos37761603_s_o_s
sots45552453_s_ots
soups75322943_soups
sous46947213_s_ous
sows75342493_s_ows
soyas84520913_soyas
soys75233933_s_oys
spoofs114011813spoofs
spooks124312933spooks
spools85115913spools
spoons84116013spoons
spoors84014033spoors
spots74424113_spots
steps76619883_steps
stoas55126023_stoas
stobs75718233_stobs
stomps105612833_stomps
stoops85917893stoops
stop66532033_stop_
stope74727243_stope
stopes84525893_stopes
stopt76528353_stopt
stoss54316343_stoss
stots54828553_stots
stoups85313273_stoups
stowps115710583_stowps
stows86622703_stows
strops86220383strops
sumps95023433_sumps
sups64834433_s_ups
swaps104819203_swaps
swobs104910893_swobs
swoops114910923swoops
swop95120503_swop_
swots85518433_swots
syboes1139343_syboes
syces106416463_syces
sykes124816863_sykes
sylis84316023_sylis
sylph1347793_sylph
sylphs1435543_sylphs
syncs104610173_syncs
synods1077953_synods
syph125413273_sy_ph
syphs13519453_syphs
syrups11277953_syrups
sysop1037193_sysop_
tops66248123__tops
toyons95512133toyons
toyos87519143toyo_s
troops85712783troops
typos106015813_typos
typps12549303_typps
unstops936993unstops
upprops1044223upprops
upshots1235193upshots
upslope1144173upslope
upsteps1133743upsteps
usurps8105073usurps
whoops14487863whoops
whops135013933_whops
woops104917523_woops
wops96634153__wops
yaps95933523__yaps
yeps95924403__yeps
yips95226703__yips
yobs96028083__yobs
yods86531183__yods
yoks116223743__yoks
yous76230653__yous
yows106433123__yows
yups96121603__yups

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127163435.31021227.1
3Display Results3433430.1103118.2
 (SQL Overall)1786913435.56332121.3
 
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.