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

75 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
obole7591714(None) 
bole66448691_bole
oboe66822941obo_e
obol65220611obol_
oboles83815831oboles
oboli73712871oboli
obols73715861obols
abele76323252abele
able66340532ab_le
abode85518812abode
above105414322above
amole75724592amole
anole55330382anole
azole145118032azole
bale66353842_bale
bile66147192_bile
bobble94115142bobble
bode75838762_bode
bogle85821682bogle
bola66035562_bola
bold75432812_bold
boles75448602_boles
boll65634752_boll
bolo65535952_bolo
bolt66254172_bolt
bone65949322_bone
boodle93215032boodle
booze164718912booze
bore66051332_bore
boule74828042boule
cobble123615262cobble
coble94823172cob_le
cole66956112_cole
dhole95215362dhole
dole56550002_dole
gobble113512982gobble
haole84820082haole
hobble133913432hobble
hole77553392_hole
jole117233822_jole
kobold1365962kobold
lobule82910062lobule
mobile103613542mobile
mole66251832_mole
nobble103814312nobble
noble74420992nob_le
obe56638642ob__e
obeli73711932obeli
obese75212422obese
oboes75717712oboes
obolus8378812obolus
odyle9349592odyle
ogle56325052o_gle
ole37155212__ole
ooze136420602o_oze
oriole6814292oriole
orle45630462o_rle
osmole8128512osmole
ovoli8358282ovoli
ovolo8339172ovolo
ovule839492ovule
ozone14310612ozone
pole65951302_pole
posole8314222posole
pozole1758912pozole
prole74527792prole
roble75223022rob_le
role45851822_role
sole46053672_sole
stole54928812stole
thole85620842thole
tole46052902_tole
vole75236982_vole
whole114418092whole
wobble133212312wobble

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 Filter178691538000.703254183.5
2DLD Change Limit53800753.47015504.3
3Display Results75750.0302500.0
 (SQL Overall)178691754.20342515.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.