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

354 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
sysops113601(None) 
sysop1037191sysop_
hysons1237632hysons
hyssops1543122hyssops
psyops1334342psy_ops
scoops105414362scoops
scops95820192s_cops
shops104222902s_hops
sloops85513622sloops
slops75026012s_lops
snoops84314172snoops
sops65244562__sops
stoops85917892stoops
stops74827282s_tops
strops86220382strops
swoops114910922swoops
swops105913972s_wops
syboes1139342syboes
synods1077952synods
syrups11277952syrups
arsons63917213arsons
asps65622093_as_ps
bebops1237623bebops
besoms105712733besoms
besots86415453besots
bishops1437033bishops
bisons83914373bisons
bloops106611343bloops
bops86037983__bops
bosoms104913053bosoms
bosons85016653bosons
byssus1133763byssus
chops125019873_chops
clops95924853_clops
coops96229643_coops
cops86751373__cops
crops96125233_crops
cusps94913673cus_ps
cyclops1635383cyclops
cymols1377193cymols
cymous1388403cymous
cysts105912773cys_ts
cytons111710183cytons
droops95110963droops
drops85719503_drops
estops84011223estops
flops105920143_flops
fops96532683__fops
galops94712623galops
gasps85415483gas_ps
glops85619553_glops
goops86620963_goops
gyps105115023gy__ps
gyrons105511223gyrons
gyros95616483gyro_s
hasps105114643has_ps
hoops105621073_hoops
hops97942633__hops
hydrops16197413hydrops
hypos1312014743hypo_s
hyps125418413hy__ps
hyson1138693hyso_n
hyssop1443413hyssop_
jalops15329593jalops
joypops2162603joypops
knops115911813_knops
knosps12405013knosps
kops107031293__kops
lisps76913913lis_ps
loops75723963_loops
lops66043353__lops
lyses84518253lys_es
lysins94610953lysins
lysis84511463lys_is
lyssas935443lyssas
masons83916513masons
maypops16104453maypops
mesons83215843mesons
misos76523293miso_s
mops85940133__mops
myope124010973my_ope
myopes13419963my_opes
myopy15457353my_opy
myoses114013843myoses
myosis114012563myosis
mysids1246563mysids
mysost1138263mysost
mysosts1234543mysosts
netops839213netops
nylons9267973nylons
oops65232673__oops
ops56641253___ops
orlops847303orlops
pesos77221623peso_s
pisos76021063piso_s
plops95920333_plops
poops94422413_poops
pops86340953__pops
postops11311713postops
preops104911943preops
props95726883_props
psoas75012983_psoas
pylons113011243pylons
pyoses114314303pyoses
pyosis114012123pyosis
pyrope132810533pyrope
pyropes142210193pyropes
pyros105718293pyro_s
rasps74316663ras_ps
rebops10311433rebops
resods74116303resods
resows93915353resows
ryots85313783ry_ots
sabots8314703sabots
sagos66123873sago_s
sajous13310583sajous
saleps85014903saleps
salols64017873salols
salons63823693salons
saloops93510133saloops
salps74423243s_alps
samps96124673s_amps
sannops936693sannops
sapors84118813sapors
saps65346373__saps
sarods74918573sarods
saros55238063saro_s
sashes94728483sashes
sasins64923103sasins
sass45035623sas__s
sasses64124393sasses
savors95616103savors
savoys12427893savoys
scalps104315233scalps
scamps125014173scamps
scarps104718603scarps
scaups105411933scaups
scions82612243scions
scoop95617163scoop_
scoots85315943scoots
scop85925523s_cop_
scope94821483s_cope
scopes104719593s_copes
scots74025913s_cots
scows106617803s_cows
scraps106017243scraps
scrips105316033scrips
scrods94111613scrods
scroops11288253scroops
sculps104611753sculps
scups95316653s_cups
seasons72614233seasons
seeps74828753s_eeps
segos64919483sego_s
seisors73212843seisors
senors63620793senors
sensors73514643sensors
sepoys1138473sepoys
serous65023563serous
serows96016393serows
setons64620173setons
setous64917373setous
setups83910463setups
sharps115516083sharps
sheols94614163sheols
ships105123773s_hips
shleps114710333shleps
shmoes114612103shmoes
shnaps1148083shnaps
shoes85429663s_hoes
shogs95319713s_hogs
shooks134515633shooks
shools94919013shools
shoos84226363s_hoos
shoots94619363shoots
shop95629843s_hop_
shots84730853s_hots
shows115324583s_hows
silos56029433silo_s
simps94719763s_imps
sips65740103__sips
sirups83710533sirups
sisals63013573sisals
sises55233833sis_es
sisses64520603sisses
situps8538783situps
skelps12407923skelps
skeps115614253s_keps
skimps14488043skimps
skips115616603s_kips
skycaps1842703skycaps
slaps76025713s_laps
sleeps83913323sleeps
slips76023723s_lips
slobs74419873s_lobs
sloes54728873s_loes
slogs64521843s_logs
sloop76118913sloop_
slop66533873s_lop_
slope75823563s_lope
slopes84820453s_lopes
slots54830533s_lots
slows85323463s_lows
slumps104313583slumps
slurps84410003slurps
smogs85112163s_mogs
snaps74719563s_naps
sneaps84510863sneaps
snips75818013s_nips
snobs74716153s_nobs
snogs66017493s_nogs
snoods74312453snoods
snooks104412833snooks
snools65715883snools
snoop75317173snoop_
snoopy11449473snoopy
snoots64216683snoots
snots55225123s_nots
snows84719893s_nows
soaps75120713s_oaps
sobs64941753__sobs
sodoms989673sodoms
sods54940213__sods
sokols10399093sokols
solons65120023solons
solos54830793solo_s
sols45448163__sols
soms66239373__soms
sons46049553__sons
sooks94425453s_ooks
soots55536213s_oots
sop57557863__sop_
soph97024203__soph
sophs104916023__sophs
sopors85215203sopors
sos37761603__so_s
sotols63714473sotols
sots45552453__sots
soups75322943s_oups
soursops1043213soursops
sous46947213__sous
sows75342493__sows
soys75233933__soys
spoofs114011813spoofs
spooks124312933spooks
spools85115913spools
spoons84116023spoons
spoors84014033spoors
spots74424113s_pots
stamps105614023stamps
steeps85215193steeps
steps76619883s_teps
stirps85011823stirps
stoas55126023s_toas
stobs75718233s_tobs
stomps105612833stomps
stooks105115373stooks
stools65117023stools
stoop75821543stoop_
stop66532033s_top_
stope74727243s_tope
stopes84525893s_topes
stopt76528353s_topt
stoss54316343s_toss
stots54828553s_tots
stoups85313273stoups
stowps115710583stowps
stows86622703s_tows
straps87721783straps
streps86218063streps
strips85719653strips
strop77422243strop_
strows96718273strows
stroys95914603stroys
stumps104912283stumps
sudors7311103sudors
sumos75720093sumo_s
sumps95023433s_umps
sunups837263sunups
sups64834433__sups
sushis9311183sushis
suss45229303sus__s
susses64221053susses
swamps135910263swamps
swaps104819203s_waps
sweeps114110513sweeps
swobs104910893s_wobs
swoons94511143swoons
swoop105213433swoop_
swoopy14487283swoopy
swop95120503s_wop_
swots85518433s_wots
sybo9714743sybo__
sycees11409653sycees
syces106416463sy_ces
sycoses1249133sycoses
sycosis1238823sycosis
sykes124816863sy_kes
sylis84316023sy_lis
sylph1347793sy_lph
sylphs1435543sylphs
sylvas12288173sylvas
symbols1435523symbols
synapse1234133synapse
synchs14408453synchs
syncoms1435943syncoms
syncope1445383syncope
syncopes1545763syncopes
syncs104610173sy_ncs
syngas10368913syngas
synod9610283syno_d
synopses1346223synopses
synopsis1346653synopsis
synths12377883synths
syph125413273sy__ph
syphons1537503syphons
syphs13519453sy_phs
syrens94911993syrens
syrup103010963syrup_
syrupy14285823syrupy
system1135743system
systems1234683systems
systole1035763systole
systoles1146483systoles
tops66248123__tops
toyshops1644433toyshops
troops85712783troops
typos106015813typo_s
typps12549303ty_pps
tyros85118593tyro_s
unstops936993unstops
visors92912223visors
wasps106714693was_ps
whoops14487863whoops
whops135013933_whops
wisps105214183wis_ps
woops104917523_woops
wops96634153__wops
xylols1634173xylols
xystos16356913xystos
xysts15558123xys_ts
xystus16354423xystus
yaps95933523_y_aps
yaups105910743_yaups
yawps13628793_yawps
yelps105712993_yelps
yeps95924403_y_eps
yips95226703_y_ips
yobs96028083_y_obs
yods86531183_y_ods
yoks116223743_y_oks
yous76230653_y_ous
yows106433123_y_ows
yups96121603_y_ups

Search took 10 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.423422437.4
2DLD Change Limit1127163548.57613143.2
3Display Results3543540.2201609.1
 (SQL Overall)1786913549.21919382.9
 
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.