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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 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
belleek134724(None) 
belleeks1444361belleeks
befleck1843942befleck
belle75827832bell_e_
belled94626192bell_ed
belles85325992bell_es
bellied104314072bellied
bellies94023722bellies
bellmen1138142bellmen
allee54932123_allee_
allees64521483_allees
bailee84526013bailee_
bailees93914383bailees
baleen8613053b_aleen
balled94926893ball_ed
baller83825203ball_er
ballers94421013ballers
ballet84733973ball_et
ballets93719513ballets
ballies93725743ballies
becloak1545043becloak
bedeck1536213be_deck
bedless1039703bedless
bedlike14369533bedlike
beebee10313063beebee_
beebees1138013beebees
beelike13379783beelike
beflea1147123befl_ea
befleaed1454663befleaed
befleas1236973befleas
beflecks1943753beflecks
belaced124112153belaced
belated103520013belated
belayed133610083belayed
belayer12339503belayer
belched154011843belched
belcher143511493belcher
belches143514343belches
beleap10410283be_leap
belie75630383be_lie_
belied95022163be_lied
belief115018603be_lief
beliefs12448583beliefs
belier84423563be_lier
beliers94617383beliers
belies84631053be_lies
believe12519773believe
believed14427923believed
believer13448423believer
believes13449403believes
belike124616283belike_
belive115415303belive_
bell66237183bell___
bellboy1445123bellboy
bellhop1445053bellhop
belling103825073belling
bellman1137183bellman
bellow114213353bell_ow
bellowed14158603bellowed
bellower13159063bellower
bellows124313303bellows
bells76432163bell__s
belly104625493bell__y
beloved13188393beloved
belted94020633be_lted
belter84720963be_lter
belters93819413belters
beltless10297713beltless
bendee94121023bendee_
bendees103913863bendees
berseem1166463berseem
berserk1334913berserk
beseem1069083be_seem
bespeak1544573bespeak
between1234693between
beveled133811133beveled
beveler124010693beveler
beweep13147253be_weep
beylik1545883beyl_ik
billed94224903bill_ed
biller84923483bill_er
billers94720833billers
billet86029723bill_et
billeted1137643billeted
billeter1037563billeter
billets94516153billets
billie85019173billie_
billies93923503billies
bleak115915383b__leak
bleed85019803b__leed
bleep95013453b__leep
bolled94722653boll_ed
bullae83416163bullae_
bulled94626493bull_ed
bullet84528613bull_et
bulleted1138393bulleted
bullets93516393bullets
bullied104514813bullied
bullier94116433bullier
bullies94121893bullies
bullneck1642933bullneck
bullock1537193bullock
bullpen1135193bullpen
bullweed1444753bullweed
burlesk1335463burlesk
callee84327293callee_
callees94117783callees
cellae84915933cellae_
celled94420323cell_ed
cleek115514913__cleek
colleen939543colleen
dellies83622213dellies
eellike1138233eellike
felled103720303fell_ed
feller94419553fell_er
fellers104117543fellers
fellest10313753fellest
fellies104119743fellies
felloe93513923felloe_
felloes104114383felloes
gelee63626983ge_lee_
gelees74116263ge_lees
gelled84718893gell_ed
gleek105315103__gleek
helled104024703hell_ed
heller93322513hell_er
helleri10389973helleri
hellers103619833hellers
hellery13329213hellery
helloed113512423helloed
helloes103717463helloes
jelled144916063jell_ed
jellied15419223jellied
jellies143816533jellies
kellies113516853kellies
leek85331733___leek
libellee10227733libellee_
libellees11274983libellees
mallee84525593mallee_
mallees93315973mallees
melee73729103me_lee_
melees83618083me_lees
melled95023023mell_ed
nellie63614813nellie_
nellies73418723nellies
pellet83326553pell_et
pelleted1138203pelleted
pellets94014783pellets
pollee83623273pollee_
pollees93215333pollees
relleno796463relleno
reseek103813133re_seek
selle54428313sell_e_
seller63824603sell_er
sellers73721323sellers
selles64426983sell_es
sleek94619043__sleek
teller63519823tell_er
tellers73717603tellers
tellies73820503tellies
welled103820213well_ed
wellie92814913wellie_
wellies103719073wellies
yelled104116253yell_ed
yeller94214513yell_er
yellers103912953yellers

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271666.71619956.4
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.18524870.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.