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

113 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
oboe6682294(None) 
obe56638641ob_e
oboes75717711oboes
obol65220611obol
obole75917141obole
abbe87627192abbe
able66340532able
abo59045962abo_
abode85518812abode
abos67734412abos
above105414322above
abye97921002abye
aloe45540192aloe
be47948942_b_e
bee56262402_bee
bo410957572_bo_
boa56954032_boa
bob76755672_bob
bod67055542_bod
bode75838752bode
bog67852412_bog
bole66448692bole
bone65949322bone
boo58163662_boo
boob85932582boob
booed85127272booed
book106836332book
boom87435672boom
boon67142172boon
boor66130682boor
boos67955032boos
boot67759372boot
booze164718912booze
bop77549482_bop
bore66051332bore
bos57966812_bos
bot59680402_bot
bow87051902_bow
box1210142342_box
boy87753562_boy
bye86134592_bye
coble94823172coble
dobie84920332dobie
doe47361952_doe
ebon66821102ebon
floe76129772floe
foe66350812_foe
froe75329992froe
gobo76126902gobo_
goboes95914442goboes
gobos86219382gobos
hobo97026082hobo_
hoboed124511682hoboed
hoboes114717452hoboes
hobos106321352hobos
hoe67562722_hoe
joe106642352_joe
kobo107422102kobo_
kobos115616892kobos
lobe65535362lob_e
lobo67229862lobo_
lobos75921842lobos
noble74420992noble
oba57531552ob_a
obas65730932obas
obes66036832obes
obese75212422obese
obey96521302obey
obi57127732ob_i
obia67923112obia
obis66226842obis
obit66837082obit
objet141213142objet
oboles83815832oboles
oboli73712872oboli
obols73715862obols
ode47446582o_de
odor55718092odor
oe28473062__oe
ogee57629882ogee
ogle56325052ogle
ogre56320742ogre
oho66534382oho_
oke75839482o_ke
ole37155212o_le
oleo46630482oleo
ombre94111802ombre
once65423082once
one37050912o_ne
ono36838032ono_
onos46229002onos
ooh67637092o_oh
oot311274692o_ot
ooze136420602ooze
ope56845242o_pe
ore36661832o_re
orle45630462orle
ose38147342o_se
owe67041032o_we
owse76321622owse
oxbow1734442oxbow
oxo107322962oxo_
ozone14310612ozone
poboy121612222poboy
robe65335642rob_e
roble75223022roble
robot7325972robot
roe36861082_roe
shoe75933442shoe
sloe45534952sloe
toe310166852_toe
voe67739052_voe
woe66651242_woe

Search took 2 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.313570897.8
2DLD Change Limit298721130.98330388.6
3Display Results1131130.0303766.7
 (SQL Overall)1786911131.326134759.4
 
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.