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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

100 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
obol6522061(None) 
oboe66822941oboe
obole75917141obole
oboli73712871oboli
obols73715861obols
abo59045962abo_
aboil72217542aboil
abos67734412abos
awol75620672awol
bal56662722_bal
bel57148462_bel
bo410957572_bo_
boa56954032_boa
bob76755672_bob
bod67055542_bod
bog67852412_bog
boil66335182boil
bola66035562_bola
bold75432812_bold
bole66448692_bole
boll65634752boll
bolo65535952_bolo
bolt66254172_bolt
boo58163662_boo
boob85932582boob
book106836332book
boom87435672boom
boon67142172boon
boor66130682boor
boos67955032boos
boot67759372boot
bop77549482_bop
bos57966812_bos
bot59680402_bot
bow87051902_bow
bowl96827702bowl
box1210142342_box
boy87753562_boy
cibol9512022cibol
col59360352_col
cool66940492cool
diobol936882diobol
diol57329132diol
dol47150652_dol
ebon66821102ebon
enol45823822enol
fool75330592fool
gaol56925412gaol
gobo76126902gobo_
gobos86219382gobos
hobo97026082hobo_
hobos106321352hobos
idol56818632idol
kobo107422102kobo_
kobold1365962kobold
kobos115616892kobos
lobo67229862lobo_
lobos75921842lobos
mol56654592_mol
mool67533862mool
oba57531552ob_a
obas65730932obas
obe56638642ob_e
obeli73711932obeli
obes66036832obes
obey96521302obey
obi57127732ob_i
obia67923112obia
obis66226842obis
obit66837082obit
oboes75717712oboes
oboles83815832oboles
obolus8378812obolus
odor55718092odor
odyl84111462odyl
oho66534382oho_
oil37452052o_il
ono36838032ono_
onos46229002onos
ooh67637092o_oh
oot311274692o_ot
opal66923522opal
oral47638122oral
osmol7138572osmol
oval77119522oval
ovoli8358282ovoli
ovolo8339172ovolo
owl66228972o_wl
oxbow1734442oxbow
oxo107322962oxo_
poboy121612222poboy
pol56449382_pol
pool65835952pool
robot7325972robot
sokol94612292sokol
sol37256622_sol
sotol54917652sotol
tool46735682tool
viol76523592viol
wool76427372wool

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.283631417.0
2DLD Change Limit298721000.84335435.3
3Display Results1001000.0303333.3
 (SQL Overall)1786911001.156154577.0
 
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.