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

189 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
jackleg213504(None) 
jacklegs2233961jacklegs
backlog1635772backlog
blackleg1734232blackleg
cackle143416922cackle_
cackled164613302cackled
cackler153812572cackler
cackles153717202cackles
hackle154916812hackle_
hackled173312492hackled
hackler163512352hackler
hackles162917062hackles
jacales16310322jacales
jacked204817522jack_ed
jacker194417582jack_er
jacket194720672jack_et
jackies202912622jackies
jacking214515262jacking
mackle143716432mackle_
mackled164111922mackled
mackles154415752mackles
rackle123917292rackle_
tackle123815732tackle_
tackled143913192tackled
tackler134013322tackler
tackles133816522tackles
ackee115825373_ack_ee
ackees124914583_ackees
aculei839793_aculei
ankle95220253_ankle_
ankled114313483_ankled
ankles104818383_ankles
anklet105618733_anklet
auklet104216833_auklet
backed155725723back_ed
backer144525523back_er
backing165523443backing
backless162910633backless
backlit15911903backlit
backlogs1746633backlogs
backset15314193backset
blacklegs1843913blacklegs
buckle144815193buckle_
buckled164411883buckled
buckler154112033buckler
buckles153416093buckles
cacklers163710703cacklers
cackling172610943cackling
cockle143913573cockle_
cockled163710823cockled
cockles153414643cockles
crackle153611253crackle_
crackled17428863crackled
crackles164111273crackles
dacker134920753dack_er
darkle113813943darkle_
darkled13378723darkled
darkles124011933darkles
deckle1312012453deckle_
deckles143312803deckles
facile112514883facile_
fickle153912973fickle_
fickler16348423fickler
grackle14338893grackle_
grackles15309183grackles
hacked164923513hack_ed
hackee154921833hack_ee
hackees165014103hackees
hacker154822693hack_er
hackie154615623hackie_
hackies163418243hackies
hacking173720613hacking
hacklers173710303hacklers
hacklier1737133hacklier
hackling183310163hackling
hackly18298733hackl_y
hackmen1836713hackmen
hackney1935123hackney
heckle153112093heckle_
heckled17318463heckled
heckler16278573heckler
heckles163711383heckles
huckle153913073huckle_
huckles163612623huckles
jacal14313703jacal__
jacals1539873jacal_s
jack175224863jack___
jackal1937613jack_al
jackals2036893jackals
jackass2034963jackass
jackdaw2442843jackdaw
jackers204214453jackers
jacketed22146533jacketed
jackets205011373jackets
jacklight2643743jacklight
jackpot2245013jackpot
jacks185219833jack__s
jacky215412343jack__y
jaconet16311483jaconet
jailed144917423ja_iled
jailer134316683ja_iler
jake155925773ja_k_e_
jakes165023643ja_k_es
jangle144416293jangle_
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
jauked18489013jauk_ed
jauking19418323jauking
jockey22408033jock_ey
keckle11359423keckle_
keckled13376503keckled
keckles12318763keckles
lacked135324653lack_ed
lacker125325623lack_er
lackey154813353lack_ey
lacking143821543lacking
mackling172710063mackling
macle96127003mac_le_
macled116718113mac_led
macles107023223mac_les
macule104115273macule_
maculed123510053maculed
macules114015133macules
maskeg13388693mask_eg
mickle143715133mickle_
mickler153310233mickler
mickles153415003mickles
muckle143413583muckle_
muckles153413253muckles
nickle123814483nickle_
nickled144010443nickled
nickles133713823nickles
package16128013package
packed154822603pack_ed
packer144223403pack_er
packet144726503pack_et
packing164420723packing
packly17228333packl_y
packmen1746313packmen
pickle144215653pickle_
pickled164011883pickled
pickles153215443pickles
racked134526083rack_ed
racker124824553rack_er
racket125229423rack_et
racking144323663racking
rankle103414883rankle_
rankled123910653rankled
rankles113114543rankles
ruckle124414583ruckle_
ruckled144111033ruckled
ruckles133414603ruckles
sacked135525213sack_ed
sacker125124843sack_er
sacking144122703sacking
shackle16409543shackle_
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
sickle124418323sickle_
sickled144713433sickled
sickles133417543sickles
spackle15369573spackle_
spackled17297803spackled
spackles16319953spackles
suckle124015963suckle_
suckled144212513suckled
suckler133413093suckler
suckles134516743suckles
tacked134723943tack_ed
tacker124224503tack_er
tacket124627493tack_et
tackey154613083tack_ey
tackier133712523tackier
tacking144421483tacking
tacklers143010773tacklers
tackless14419483tackless
tackling153211123tackling
tickle124616743tickle_
tickled144313133tickled
tickler133612653tickler
tickles133416853tickles
wacke145918623wack_e_
wacker154920123wack_er
wackes154717713wack_es
wackier16369733wackier
yacked164516793yack_ed
yacking174315683yacking

Search took 7 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.423422437.4
2DLD Change Limit1340271895.68623571.4
3Display Results1891890.0633000.0
 (SQL Overall)1786911896.17228951.9
 
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.