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

115 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
sloper8461591(None) 
eloper85414151eloper
loper75129231_loper
slope75823561slope_
sloped94216851sloped
slopers94213091slopers
slopes84820451slopes
slower94016151slower
stoper84320101stoper
aslope839012aslope_
blooper11358532blooper
blower115316572blower
cloner84418092cloner
closer84918202closer
clover114617122clover
cooper104221122cooper
coper95336092_coper
doper86128392_doper
elope75219342elope_
eloped95914142eloped
elopers95112942elopers
elopes85918162elopes
flopper14328472flopper
flower124815502flower
glover104513532glover
glower105114932glower
groper94517252groper
hooper114518312hooper
hoper105829142_hoper
leper74820742_leper
loner55431042_loner
looper83817112looper
lope65941922_lope_
loped85128332_loped
lopers84424142_lopers
lopes76437342_lopes
lopper103717202_lopper
loser54728672_loser
lover85526452_lover
lower85830412_lower
moper94925922_moper
plover115312612plover
plower114315062plower
proper104319952proper
roper75431912_roper
sapper103822352sapper
scooper113812032scooper
scope94821482scope_
scoped115116652scoped
scopes104719592scopes
scorer84818262scorer
scoter83815482scoter
shaper114119932shaper
shoer84722162sho_er
shopper143312632shopper
shover124515992shover
shower124315112shower
simper103616292simper
sipper103920992sipper
slaker104219272slaker
slapper113512462slapper
slater64429182slater
slaver94419612slaver
slayer93916332slayer
sleeper93211562sleeper
slicer84117602slicer
slider73918362slider
slier54827242sl_ier
slipe75626132slipe_
sliped95417062sliped
slipes84921412slipes
slipper113712982slipper
sliver94116592sliver
slobber11388902slobber
sloe45534952slo_e_
sloes54728872slo_es
slogger94310482slogger
slop66533872slop__
slopped123511442slopped
sloppier1255702sloppier
sloppy1395302sloppy
slops75026012slop_s
slotter73314452slotter
sloven9389632sloven
slowed104617072slowed
slyer85515122sl_yer
slype105112362slype_
slypes114410482slypes
smoker124311692smoker
sniper84413642sniper
snooper93511532snooper
snorer64316762snorer
soaper84517872soaper
sober74822412s_ober
solder73921342solder
solver94016702solver
sooner64220462sooner
sopor74016492s_opor
sorer56236592s_orer
sower85229312s_ower
stoker104417622stoker
stomper114111232stomper
stoner65823202stoner
stooper93813192stooper
stope74727242stope_
stoped94721012stoped
stopers94217372stopers
stopes84525892stopes
stopper113012602stopper
storer64721672storer
stover94115642stover
super74924482s_uper
supper104115432supper
swooper12389172swooper
toper75231022_toper

Search took 3 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 Limit825511152.47033421.5
3Display Results1151150.0333484.8
 (SQL Overall)1786911152.84662786.7
 
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.