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

163 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
hackney193512(None) 
hackneys2033681hackneys
cockney1835872cockney
hacked164923512hack_ed
hackee154921832hack_ee
hackees165014102hackees
hacker154822692hack_er
hackie154615622hackie_
hackies163418242hackies
hackle154916812hackle_
hackled173312492hackled
hackler163512352hackler
hackles162917062hackles
hackly18298732hack_ly
hackmen1836712hackmen
hackneyed2242242hackneyed
hawkey19507632hawk_ey
hickey185011992hick_ey
hockey184813152hock_ey
lackey154813352lack_ey
tackey154613082tack_ey
ackee115825373_ack_ee
ackees124914583_ackees
acne66625873_ac_ne_
acned87520673_ac_ned
acnes75922623_ac_nes
backed155725723back_ed
backer144525523back_er
backset15314193backset
baloney1237483baloney
barney115314453ba_rney
cackle143416923cackle_
cackled164613303cackled
cackler153812573cackler
cackles153717203cackles
cakey145517273ca_k_ey
carney115315703ca_rney
cockneys1934493cockneys
coney105932883__coney
cracknel1643703cracknel
dacker134920753dack_er
darkey145212423dark_ey
dickey165913523dick_ey
fakey155515423fa_k_ey
hacek145411843hac__ek
hack135134543hack___
hackberry2362203hackberry
hackbut1845713hackbut
hackers164619043hackers
hacking173720613hacking
hacklers173710303hacklers
hacklier1737133hacklier
hackman1836433hackman
hackneying2342443hackneying
hacks144928713hack__s
hacksaw1943713hacksaw
hairnet10911703hairnet
hake115637843ha_k_e_
hakeem15407383ha_keem
hakes126034303ha_k_es
handy125520873ha__ndy
hanked144220603hank_ed
hanker134622093hank_er
hankie133915713hankie_
hankies143617763hankies
hanky155418293ha__nky
harked145422553hark_ed
harken135116343hark_en
harkened1637483harkened
harkener1537573harkener
harkens144112863harkens
havened14429243havened
hawked174712673hawk_ed
hawker164812663hawk_er
hawkeys20414703hawk_eys
hawkie163810093hawkie_
hawkies173311243hawkies
hayey144812533ha__yey
heckle153112093heckle_
heckled17318463heckled
heckler16278573heckler
heckles163711383heckles
hickeys19508223hick_eys
hickie153812473hickie_
hickies163614743hickies
hickory1943903hickory
hocked165521303hock_ed
hocker155118563hock_er
hockeys19509273hock_eys
hokey155422183h_ok_ey
honey115629913h__oney
honkey165113823honk_ey
hookey164713933hook_ey
huckle153913073huckle_
huckles163612623huckles
hunkey164210883hunk_ey
jacked204817523jack_ed
jacker194417583jack_er
jacket194720673jack_et
jackies202912623jackies
jackleg2135043jackleg
jacky215412343jack__y
jaconet16311483jaconet
jockey22408033jock_ey
lacey105820913lac__ey
lacked135324653lack_ed
lacker125325623lack_er
lackeys16458263lack_eys
lacquey21143803lacquey
lacune8169673lacune_
lacunes9159623lacunes
mackle143716433mackle_
mackled164111923mackled
mackles154415753mackles
mickey174211853mick_ey
pacey126720283pac__ey
packed154822603pack_ed
packer144223403pack_er
packet144726503pack_et
packly17228333pack_ly
packmen1746313packmen
packness1636933packness
racked134526083rack_ed
racker124824553rack_er
racket125229423rack_et
rackety16499113rackety
rackle123917293rackle_
rickey154613973rick_ey
sacked135525213sack_ed
sacker125124843sack_er
sawney12387603sa_wney
shacked174015393shack_ed
shackle16409543shackle_
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
shackoes17367853shackoes
tacked134723943tack_ed
tacker124224503tack_er
tacket124627493tack_et
tackier133712523tackier
tackify1934493tackify
tackily1637503tackily
tackle123815733tackle_
tackled143913193tackled
tackler134013323tackler
tackles133816523tackles
tacky145617443tack__y
tawney12338233ta_wney
thacked173810203thack_ed
vacancy1744443vacancy
wacke145918623wack_e_
wacker154920123wack_er
wackes154717713wack_es
wackier16369733wackier
wackily1936053wackily
wacky174714933wack__y
waney115120323wa__ney
whacked20458623whack_ed
whacker19368503whack_er
whackier2044673whackier
whacky21556493whack__y
yacked164516793yack_ed

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.390458182.1
2DLD Change Limit1340271635.84322938.0
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.29628381.7
 
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.