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

162 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
obey9652130(None) 
bey86645421_bey
obe56638641obe_
obes66036831obes
obeys107010641obeys
abbey125714932abbey
abed79734132abed
abet610547942abet
ably99725132ably
aby810238062ab_y
abye97921002abye
bay89661642_bay
be47948942_be_
bed67950622_bed
bee56262402_bee
beg65944132_beg
bel57148462_bel
ben56554922_ben
bes56557432_bes
bet58376672_bet
bevy127115222_bevy
beys913829552_beys
bobby114814662bobby
body107425672body
bogey115220232bogey
bogy106426192bogy
boney105227312boney
bony96732082bony
boxy166420732boxy
boy87753562_boy
buy86436542_buy
by77529232_b_y
bye86134592_bye
cobby145516412cobby
coney105932882coney
cooey105828222cooey
cosey106226712cosey
covey136121782covey
cozey196718542cozey
dey77243372_dey
dobby136013632dobby
doby106022162dob_y
dogey105719512dogey
dopey116020352dopey
fey95940882_fey
fley106626852fley
fogey125617872fogey
foley115222302foley
gey75738302_gey
gley85724652gley
goby106021082gob_y
gooey95522862gooey
grey85624042grey
hey96741062_hey
hobby155913732hobby
hokey155422182hokey
holey115626902holey
homey135924842homey
honey115629912honey
hooey114926602hooey
hosey116127022hosey
ibex133813482ibex
joey145719332joey
jokey195014692jokey
key105833332_key
ley66246812_ley
lobby125113922lobby
lobe65535362lobe_
lobed86022132lobed
lobes75331002lobes
looey84822912looey
money104826842money
mopey124821822mopey
mosey105922872mosey
motey105922952motey
nobby125513462nobby
nobly105314402nobly
nosey85619882nosey
oaky116419952oaky
oba57531552ob_a
obas65730932obas
obeah1038992obeah
obeli73711932obeli
obese75212422obese
obeyed1235822obeyed
obeyer1135892obeyer
obi57127732ob_i
obia67923112obia
obis66226842obis
obit66837082obit
objet141213142objet
oboe66822942oboe
oboes75717712oboes
obol65220612obol
ode47446582ode_
odea56224572odea
odes57243242odes
oe28473062o_e_
oes35866192o_es
ofay106416102ofay
ogee57629882ogee
ohed87825182ohed
oily77932252oily
okay115917662okay
oke75839482oke_
okeh114615322okeh
okes84936342okes
oldy85316842oldy
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
omber95316442omber
omen66828182omen
omer67028392omer
one37050912one_
onery8414122onery
ones46146532ones
only75319722only
oozy167018132oozy
ope56845242ope_
oped76230152oped
open66427002open
opes65942612opes
orbed85516192orbed
orby97519602orby
ore36661832ore_
ores46056682ores
orgy85218002orgy
ose38147342ose_
oses46641512oses
oven76624142oven
over77227342over
owe67041032owe_
owed86833872owed
owes75137102owes
oxen116218592oxen
oxes116530722oxes
oxeye1536912oxeye
oxy136320982o_xy
oy58950132o__y
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
poboy121612222poboy
pogey116017892pogey
pokey145318972pokey
prey96228482prey
quey164616472quey
robe65335642robe_
robed85323732robed
robes75133302robes
ropey106021872ropey
sober74822412sober
sooey84522432sooey
stey76224412stey
they107223752they
toby96322292tob_y
toney86027412toney
trey77228792trey
whey135018712whey
zooey173914802zooey

Search took 5 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 Filter178691298720.330541487.9
2DLD Change Limit298721623.6238245.1
3Display Results1621620.0802025.0
 (SQL Overall)1786911624.03344307.2
 
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.