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 “slopes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

135 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
slopes8482045(None) 
elopes85918161elopes
lopes76437341_lopes
scopes104719591scopes
slipes84921411slipes
sloes54728871slo_es
slope75823561slope_
sloped94216851sloped
sloper84615911sloper
slopers94213091slopers
slops75026011slop_s
slypes114410481slypes
stopes84525891stopes
aloes54933672alo_es
aslope839012aslope_
blokes123813882blokes
blypes13357542blypes
clepes104214622clepes
clones84526562clones
clops95924852clop_s
closes85425592closes
cloves114918822cloves
clozes174915562clozes
copes97747102_copes
dopes84935042_dopes
elope75219342elope_
eloped95914142eloped
eloper85414152eloper
elopers95112942elopers
floes85528142flo_es
flops105920142flop_s
globes94314542globes
glops85619552glop_s
gloves104115182gloves
glozes164313352glozes
gropes95220402gropes
hopes105835642_hopes
lobes75331002_lobes
lodes66436912_lodes
loges66534202_loges
lope65941922_lope_
loped85128332_loped
loper75129232_loper
lopers84424142_lopers
lops66043352_lop_s
lores55045402_lores
loses56742012_loses
loupes84918052_loupes
loves85332012_loves
lowes85732462_lowes
loxes125227472_loxes
mopes95134982_mopes
myopes13419962myopes
opes65942612__opes
plops95920332plop_s
popes95933812_popes
ropes75940062_ropes
scapes105122262scapes
scones84521302scones
scope94821482scope_
scoped115116652scoped
scops95820192scop_s
scores84725922scores
shapes115124952shapes
shoes85429662sho_es
shoppes143411402shoppes
shops104222902shop_s
shores94830412shores
shotes95321912shotes
shoves124919422shoves
sipes76036952s_ipes
slakes104021882slakes
slaps76025712slap_s
slates64934062slates
slaves95023022slaves
sleeps83913322sleeps
slices84022852slices
slides73922182slides
slimes84722042slimes
slipe75626132slipe_
sliped95417062sliped
slips76023722slip_s
slobs74419872slo_bs
sloe45534952slo_e_
slogs64521842slo_gs
sloids73712692sloids
slojds14345472slojds
sloops85513622sloops
slop66533872slop__
slopped123511442slopped
sloppy1395302sloppy
sloshes103811802sloshes
sloths94911892sloths
slots54830532slo_ts
sloven9389632sloven
slovens10316572slovens
slowed104617072slowed
slower94016152slower
slowest10168712slowest
slows85323462slo_ws
sloyds10346292sloyds
slues54527172sl_ues
slype105112362slype_
smokes124814342smokes
snipes83917392snipes
snores64324322snores
sokes95031422s_okes
soles55547922s_oles
solves95018222solves
sones55444142s_ones
sophs104916022s_ophs
sops65244562s_op_s
sores55454282s_ores
splores91910952splores
spodes94817432spodes
spokes124417212spokes
spores84726612spores
stapes85028732stapes
stipes84524052stipes
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stope74727242stope_
stoped94721012stoped
stoper84320102stoper
stopers94217372stopers
stops74827282stop_s
stores65533662stores
stoves93818922stoves
stupes84116952stupes
supes75628302s_upes
swipes114114332swipes
swops105913972swop_s
topes76941762_topes
tropes84824352tropes

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511352.61031628.7
3Display Results1351350.0462934.8
 (SQL Overall)1786911352.99959583.5
 
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.