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

478 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
orlops84730(None) 
orlons6411011orlons
orlop7410901orlop_
clops95924852_clops
collops112611752collops
crops96125242cr_ops
dollops10287962dollops
droops95110962droops
drops85719502dr_ops
flops105920142_flops
galops94712622galops
glops85619552_glops
jalops15329592jalops
lollops9227442lollops
lops66043352__lops
oops65232672o__ops
ordos65216202ordo_s
orles55326212orl_es
orlon5415002orlo_n
orzos143311252orzo_s
oxlips1544432oxlips
plops95920332_plops
preops104911942preops
props95726882pr_ops
slops75026012_slops
troops85712782troops
allods73615083allods
allots64019173allots
allows94517683allows
alloys94014563alloys
aloes54933673_aloes
alps65529243_al_ps
arbors84717883arbors
ardors74416873ardors
argols74514613argols
argons75018203argons
argots74116033argots
arles56735743arl_es
armors85017813armors
arrows92813493arrows
arsons63917213arsons
arvos86015663arvo_s
aslope839013aslope
azlons154110423azlons
barhops14288113barhops
barlows12259983barlows
bebops1237623bebops
belons84119413belons
belows114614183belows
blips95615783_blips
blobs95620033_blobs
blocs95219653_blocs
blogs85319233_blogs
bloops106611343bloops
blots75626173_blots
blows105423833_blows
bolos75531373bolo_s
bops86037983__bops
borons85520543bor_ons
borrows12349263borrows
borzois1835833borzois
brios74725723brio_s
broods95416383broods
brooks125813883brooks
brooms104915873brooms
broos75126413br_oos
bros65635663br_o_s
brows105425983br_ows
brulots946223brulots
burlaps1156253burlaps
calos74431903calo_s
carhops14329703carhops
celoms10412123celoms
chops125019873_chops
claps95626183_claps
clips96018303_clips
clods85320863_clods
clogs85519553_clogs
clomps125212233_clomps
clons75228133_clons
clop86929893_clop_
clots75627643_clots
cloys104916943_cloys
coeloms1139063coeloms
collop107312313collop_
cologs96517353cologs
colons86028683colons
colors86622373colors
coops96229643_coops
coplots11511593coplots
cops86751373__cops
cordons104415763cordons
cormous11312353cormous
corps95927043cor__ps
cowflops1842983cowflops
cowplops1743173cowplops
cramps125615563cramps
craps95328643cr_aps
creeps104213623creeps
crimps124613453crimps
crisps104411513crisps
crocs95722433cr_ocs
crooks124914413crooks
croons85418423croons
crop87628633cr_op_
cross75124503cr_oss
croups104312553croups
crows105727313cr_ows
crumps124514343crumps
cruors838643cruors
cyclops1635383cyclops
doblons1037043doblons
dollop9259363dollop_
dolors75115313dolors
doowops1363943doowops
dorps85419223dor__ps
drips85417233dr_ips
drolls75312393drolls
drools74412813drools
droop85814823droop_
droopy12458243droopy
drop75324403dr_op_
dropsy12497473dr_opsy
dropt86924433dr_opt
dross65418093dr_oss
drylots1143743drylots
earlaps936393earlaps
elope75219343_elope
elopes85918163_elopes
ergots74512373ergots
eros45238453er_o_s
errors63311313errors
estops84011223estops
felons93615763felons
filos86125383filo_s
flaps105621383_flaps
flips105117743_flips
flocs105519233_flocs
floes85528143_floes
flogs95919963_flogs
flop96925453_flop_
floss85118263_floss
flows115822363_flows
follows13409923follows
fops96532683__fops
forceps14466983forceps
fordoes11311963fordoes
foretops13137483foretops
forgoes11311353forgoes
forlorn1096423forlorn
formols12299413formols
fraps105620553fr_aps
froes86126693fr_oes
frogs96220773fr_ogs
frons86124043fr_ons
frows116623103fr_ows
frumps13479783frumps
gallops103211653gallops
galop84716223galop_
globs85616403_globs
gloms85219783_gloms
glop76724633_glop_
gloss64319623_gloss
glows95518033_glows
goops86620963_goops
gorgons938853gorgons
gorps85316993gor__ps
gramps114114273gramps
grasps9489253grasps
griots74713643griots
grips85520133gr_ips
grogs76319413gr_ogs
groks105716123gr_oks
grooms94512523grooms
grope84821613gr_ope
gropes95220403gr_opes
gross65421693gr_oss
grots65025853gr_ots
groups94210513groups
grows95523923gr_ows
grumps114510573grumps
gulps84715073gul_ps
haloes94623863haloes
halons95720713halons
halos85230253halo_s
harlots103413293harlots
helos84928063helo_s
helots95217703helots
helps105219343hel_ps
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
hoops105621073_hoops
hops97942633__hops
horrors1078693horrors
igloos738033igloos
irons55324133ir_ons
jalaps15299183jalaps
jalop144212603jalop_
jalopy18325863jalopy
joypops2162603joypops
juleps1535623juleps
keleps12478813keleps
kelps115116423kel_ps
kilos95021473kilo_s
knops115911813_knops
kolos94921213kolo_s
kops107031293__kops
kreeps12427413kreeps
kroons103711243kroons
laps66848873__laps
lilos55821873lilo_s
lips67141443__lips
lobs66441083__lobs
logs57343113__logs
lollop8238783lollop_
lollopy12234773lollopy
loops75723963_loops
loos49051123__loos
lop58255313__lop_
lope65941923__lope
lopes76437343__lopes
loss45337963__loss
lots47652093__lots
loups75319623__loups
lows75843013__lows
melons84117713melons
merlons93311273merlons
merlots92710123merlots
milos75428013milo_s
mops85940133__mops
morions94014643morions
morons84919543mor_ons
morros83714673morro_s
morrows12318723morrows
netops839223netops
nolos54423353nolo_s
nylons9267973nylons
oarless73913373oarless
oarlock1336123oarlock
oarlocks1445103oarlocks
oblong935383oblong
oblongs1033533oblongs
oboes75717713o_boes
oboles83815833oboles
obols73715863o_bols
obolus8378813obolus
ocelots977233ocelots
octopi1036533octopi
octopus1144813octopus
odeons739023odeons
odious749933odious
odors64514283o_dors
oglers74313183oglers
ogles65223183ogl_es
oilcups1143333oilcups
oilers64721193oilers
oils46337973oil__s
olds55926573o_l_ds
oleos55419683o_leos
oles46453473o_l_es
olios54520853o_lios
ollas54218283o_llas
ology94113113o_logy
onions64016433onions
onlays9398713onlays
onload7268633onload
onloads8246673onloads
onos46229003o_no_s
oohs75220693o__ohs
oology103210253oology
oolong738073oolong
oolongs845953oolongs
oots46446443o__ots
ops56641253___ops
orals55826483or_als
orangs74116033orangs
orates64328613orates
orators7313823orators
orbits84211443orbits
orbless937493orbless
orbs66626253or__bs
orcas75918623or_cas
orchis11710773orchis
orcins83313433orcins
orcs67025433or__cs
orders74315993orders
ordo54622353ordo__
oreads73915773oreads
ores46056683or__es
organs7912913organs
orgies72316093orgies
orgone71110913orgone
orgones81010793orgones
orgulous944213orgulous
oribis838833oribis
oriels64914623oriels
oriole6814293oriole
orioles7412993orioles
orisons7310563orisons
orle45630463orl__e
ormers84316143ormers
ormolu845833ormolu
ormolus934743ormolus
ornis54616773or_nis
orology11319463orology
orpins83614163orpins
orris54516553or_ris
ors35750113or___s
orts46538333or__ts
oryxes1674523oryxes
orzo134516783orzo__
osmols8137313osmols
osmous8138183osmous
ottos54714323otto_s
ouzos143210413ouzo_s
overlaps13219523overlaps
overtops1338513overtops
ovolos9257203ovolos
owlets93110393owlets
owls76022933owl__s
oxbows1833713oxbows
oxlip1456883oxlip_
palps94719563pal_ps
parlors9312913parlors
parlous9414293parlous
pilots84018873pilots
pilous84717753pilous
plods85719293_plods
plop86625743_plop_
plots75025673_plots
plows105419903_plows
ploys105816593_ploys
polos76129913polo_s
polyps13479763polyps
poops94422413_poops
pops86340953__pops
pornos85015253porno_s
porous84419483por_ous
postops11311713postops
praos74923563prao_s
preop94715873preop_
preps96220693pr_eps
primps124711823primps
prions84317783prions
priors83914483priors
proas75028803pr_oas
prods85523553pr_ods
profs105120893pr_ofs
progs86624153pr_ogs
proles84627203proles
prologs103512133prologs
proms95426413pr_oms
proofs114511683proofs
prop85932813pr_op_
pros65742783pr_o_s
pross76529403pr_oss
prows106327013pr_ows
psyops1334343psyops
pulps95116483pul_ps
pylons113011243pylons
ramps96224633_ramps
raps66247733_r_aps
rasps74316663_rasps
reaps75626193_reaps
rebops10311433rebops
repos74725793_repos
repps95114343_repps
reps65937953_r_eps
rhos76319063_rho_s
riots54922013_riots
rips66237433_r_ips
robots8313153robots
robs65837873_r_obs
rocs65533663_r_ocs
rods56442063_r_ods
roes45954143_r_oes
roles56747983rol_es
rolfs84817123rol_fs
rollmops1243003rollmops
rolls55326233rol_ls
romps94617543_romps
roms67038963_r_oms
roods65125283_roods
roofs85321153_roofs
rooks95325043_rooks
rooms75324683_rooms
roots55933673_roots
rope65542913_r_ope
ropes75940063_r_opes
ropy96323413_r_opy
rotors64917953rotors
rotos56027883roto_s
rots46454093_r_ots
roups75118903_roups
rows75941753_r_ows
rumps95922293_rumps
ryots85313783_ryots
saleps85014903saleps
salols64017873salols
salons63823693salons
saloops93510133saloops
salps74423243sal_ps
scollops12235703scollops
scoops105414363scoops
scops95820193_scops
scroops11288253scroops
shleps114710333shleps
shops104222903_shops
silos56029433silo_s
slaps76025713_slaps
slips76023723_slips
slobs74419873_slobs
sloes54728873_sloes
slogs64521843_slogs
sloops85513623sloops
slop66533873_slop_
slope75823563_slope
slopes84820453_slopes
slots54830533_slots
slows85323463_slows
snoops84314173snoops
solons65120023solons
solos54830793solo_s
sops65244563__sops
sordors8310013sordors
sorgos74514663sorgo_s
sorrows10278403sorrows
soursops1043213soursops
stoops85917893stoops
stops74827283_stops
strops86220383strops
swoops114910923swoops
swops105913973_swops
sysops1136013sysops
talons64019443talons
telos55424523telo_s
tops66248123__tops
toros54336193tor_o_s
torous64319033tor_ous
torpors939383torpors
torsos64815733torso_s
tramps105114453tramps
traps75727483tr_aps
triols66117803triols
trios55528093trio_s
tripos84014923tripos
trips74923363tr_ips
trogs67022603tr_ogs
trois57226093tr_ois
trollops1044813trollops
trolls64613943trolls
tromps104911703tromps
troop76417533troop_
trop66833303tr_op_
trope75725803tr_ope
tropes84824353tr_opes
trots56629943tr_ots
trows88826183tr_ows
troys86418613tr_oys
trumps104611883trumps
tulips8137253tulips
urps66920483ur__ps
valors93413773valors
vrooms11398713vrooms
vrows116115263vr_ows
wallops123410413wallops
whoops14487863whoops
whops135013933_whops
woops104917523_woops
wops96634153__wops
workups1633613workups
worlds10568733worl_ds
wraps105617153wr_aps
xylols1634173xylols
yelps105712993yel_ps

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.376475242.0
2DLD Change Limit1127164785.28021347.7
3Display Results4784780.1403414.3
 (SQL Overall)1786914785.79630830.1
 
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.