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

121 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
oboes7571771(None) 
goboes95914441goboes
hoboes114717441hoboes
obes66036831ob_es
oboe66822941oboe_
oboles83815831oboles
obols73715861obols
abbes96723522abbes
ables75935542ables
abodes94417512abodes
abos67734412abo_s
aboves114512842aboves
abyes105518532abyes
aloes54933672aloes
bees65453382_bees
bes56557432_b_es
boas66150832_boas
bobs86340652_bobs
bodes84935102bodes
bods76244712_bods
bogs75742752_bogs
boles75448602boles
bones76446532bones
boobs96221992boobs
booed85127272booed
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032_boos
boots75837972boots
boozes174916522boozes
bops86037982_bops
bores76448252bores
bos57966812_bo_s
boss65938342_boss
bots66453952_bots
bows96242862_bows
boxes145625072boxes
boys96737332_boys
buboes104513992buboes
byes95230532_byes
cobles104622882cobles
dobies94422092dobies
dodoes85716102dodoes
does56554472_does
ebons74316092ebons
floes85528142floes
foes76543442_foes
froes86126692froes
gobies95418062gobies
gobos86219382gobo_s
goes55644092_goes
hoboed124511682hoboed
hobos106321352hobo_s
hoes75755732_hoes
joes116635892_joes
kobos115616892kobo_s
lobes75331002lob_es
lobos75921842lobo_s
locoes85516582locoes
mojoes15399522mojoes
nobles83319722nobles
noes45845392_noes
oases55330982oases
oaves84925612oaves
obas65730932ob_as
obe56638642ob_e_
obese75212422ob_ese
obey96521302ob_ey
obeys107010642obeys
obias76116862obias
obis66226842ob_is
obits74617552obits
objet141213142objet
objets15125322objets
oboist8312682oboist
obol65220612obo_l
obole75917142obole
oboli73712872oboli
obolus8378812obolus
obsess845942obsess
obtest81213012obtest
odes57243242o_des
odors64514282odors
oes35866192__oes
ogees65119142ogees
ogles65223182ogles
ogres65818632ogres
okes84936342o_kes
oleos55419682oleos
oles46453472o_les
ombres103911142ombres
ones46146532o_nes
onos46229002ono_s
oohs75220692o_ohs
oops65232672o_ops
oots46446442o_ots
oozes145418712oozes
opes65942612o_pes
ores46056682o_res
orles55326212orles
oses46641512o_ses
owes75137102o_wes
oxbows1833712oxbows
oxes116530722o_xes
oyes74940132o_yes
ozones1539392ozones
poboys1397312poboys
robes75133302rob_es
robles85321692robles
robots8313152robots
roes45954142_roes
shoes85429662shoes
sloes54728872sloes
syboes1139342syboes
tobies84521022tobies
toes46956442_toes
voes75432822_voes
woes76440662_woes
yobboes1445582yobboes

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 Filter178691538000.296603685.8
2DLD Change Limit538001211.56334421.0
3Display Results1211210.0304033.3
 (SQL Overall)1786911211.88994595.6
 
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.