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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
obeys10701064(None) 
beys913829551_beys
obes66036831obe_s
obey96521301obey_
abbeys13538422abbeys
abets75621672abets
abyes105518532abyes
abys97221882ab_ys
bays97143912_bays
beds75937782_beds
bees65453382_bees
begs75733832_begs
bels66142492_bels
bens65945702_bens
bes56557432_be_s
bets67051442_bets
bey86645422_bey_
bogeys124510912bogeys
boys96737332_boys
buys95726792_buys
byes95230532_byes
bys85229462_b_ys
coneys115218422coneys
cooeys114914482cooeys
coseys115215812coseys
coveys145413502coveys
cozeys204610912cozeys
deys85027472_deys
dogeys115510662dogeys
fleys117015602fleys
fogeys13509262fogeys
foleys123810462foleys
gleys96514852gleys
greys96614852greys
homeys145012872homeys
honeys124016082honeys
hooeys125512312hooeys
hoseys124614002hoseys
joeys15518042joeys
keys116322162_keys
leys76430182_leys
lobes75331002lobe_s
looeys95110122looeys
moneys115513622moneys
moseys114711702moseys
obas65730932ob_as
obe56638642obe__
obeah1038992obeah
obeahs1135862obeahs
obeli73711932obeli
obelus8348402obelus
obese75212422obese
obeyed1235822obeyed
obeyer1135892obeyer
obeyers1234812obeyers
obias76116862obias
obis66226842ob_is
obits74617552obits
objets15125322objets
oboes75717712oboes
obols73715862obols
obsess845942obsess
odes57243242ode_s
oes35866192o_e_s
ofays11488922ofays
ogees65119142ogees
okays12609442okays
okehs12477462okehs
okes84936342oke_s
oleos55419682oleos
oles46453472ole_s
ombers104214402ombers
omens75618962omens
omers76923192omers
ones46146532one_s
opens76118552opens
opes65942612ope_s
ores46056682ore_s
oses46641512ose_s
ovens86217452ovens
overs85224792overs
owes75137102owe_s
oxes116530722oxe_s
oxeye1536912oxeye
oxeyes1635892oxeyes
oyers87620882oyers
oyes74940132oye_s
poboys1397312poboys
pogeys124110352pogeys
pokeys15529512pokeys
preys105717782preys
queys17398362queys
robes75133302robe_s
sobers85218862sobers
treys85018212treys
wheys145911552wheys

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 Filter178691538000.373479064.3
2DLD Change Limit53800961.61033416.1
3Display Results96960.0303200.0
 (SQL Overall)178691962.01388768.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.