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

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

188 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
tacker12422450(None) 
backer144525521backer
dacker134920751dacker
hacker154822691hacker
jacker194417581jacker
lacker125325621lacker
packer144223401packer
racker124824551racker
sacker125124841sacker
stacker134416261stacker
tacked134723941tacked
tackers134319621tackers
tacket124627491tacket
tackey154613081tackey
tackier133712521tackier
tackler134013321tackler
taker95229001ta_ker
talker103916221talker
tanker104521121tanker
ticker124321501ticker
tracker133515171tracker
tucker124316951tucker
wacker154920121wacker
ackee115825362_ackee
asker96418782_asker
attacker14144982attacker
backed155725722backed
backers153821882backers
baker115629542ba_ker
balker124519162balker
banker124222732banker
barker124822862barker
bicker144819172bicker
blacker154513512blacker
bucker145420462bucker
cackler153812572cackler
calker124917082calker
canker124422522canker
clacker153813772clacker
cocker144320392cocker
cracker153114172cracker
dackers143417042dackers
daiker115113032daiker
danker114319662danker
darker114718692darker
decker135215992decker
dicker134521402dicker
docker134417652docker
ducker134317992ducker
facer105525052fac_er
faker124824592fa_ker
fucker153414422fucker
gawker14559352gawker
hacked164923512hacked
hackee154921832hackee
hackers164619042hackers
hackler163512352hackler
hanker134622092hanker
hawker164812662hawker
hocker155118562hocker
icker114018442_icker
jacked204817522jacked
jackers204214452jackers
jacket194720672jacket
kicker114116182kicker
knacker12307912knacker
lacer75833752lac_er
lacier84020092lacier
lacked135324652lacked
lackers134120542lackers
lackey154813352lackey
laker95432872la_ker
lanker104123002lanker
larker104519242larker
licker125222042licker
locker124019422locker
macer912126942mac_er
maker114127812ma_ker
marker124420392marker
masker124416102masker
mocker143315442mocker
mucker143816392mucker
necker124012792necker
nicker123818702nicker
ocker113915752_ocker
pacer96131612pac_er
pacier105018682pacier
packed154822602packed
packers153818892packers
packet144726502packet
parker124121372parker
pecker144615362pecker
picker144422172picker
pucker143817632pucker
racer75233022rac_er
racier85120972racier
racked134526082racked
rackers134320452rackers
racket125229422racket
raker94529792ra_ker
ranker105021902ranker
rocker124319572rocker
sacked135525212sacked
sackers133820222sackers
saker95132022sa_ker
sicker124023902sicker
slacker133915292slacker
smacker153410582smacker
snacker133112602snacker
stacked143416122stacked
stackers143413562stackers
stalker113912252stalker
starker114114692starker
sticker133515882sticker
stocker133713082stocker
sucker124120662sucker
taber73825822ta_ber
tace65342512tac_e_
taces76237802tac_es
tacet75840022tac_et
tache106222372tache_
taches114224172taches
tack106536292tack__
tackets134914362tackets
tackle123815732tackle
tackled143913182tackled
tacklers143010772tacklers
tackles133816522tackles
tacks115430132tack_s
tacky145617442tack_y
tagger84017692tagger
tailer63823732tailer
take84739262ta_ke_
taken94819142ta_ken
takers103923742ta_kers
takes94437792ta_kes
talcked1446342talcked
taler56034862ta_ler
talked114015402talked
talkers113513212talkers
talkier114011842talkier
taller63721962taller
tamer75230102ta_mer
tamper104618512tamper
tanked113919292tanked
tankers113416912tankers
tanner63722282tanner
taper74829772ta_per
tapper104419612tapper
tarter64023562tarter
tasked114714642tasked
taster64930572taster
tater54138612ta_ter
tatter64024572tatter
tauter64318022tauter
tawer85223442ta_wer
taxer125019362ta_xer
teacher123714832teacher
thacked173810202thacked
thanker14309592thanker
thicker163611022thicker
thwacker2042872thwacker
ticked134720522ticked
tickers133617722tickers
ticket124524852ticket
tickler133612652tickler
tinker103619922tinker
tocher114014912tocher
toker95924912t_oker
tracer84820232trac_er
tracked143716132tracked
trackers143512842trackers
tricker134615522tricker
trucker134010732trucker
tucked134017492tucked
tuckers134014352tuckers
tucket124219482tucket
tusker104212192tusker
wacke145918622wacke_
wackes154717712wackes
wackier16369732wackier
waker125526592wa_ker
walker133913992walker
wanker134219972wanker
whacker19368502whacker
wicker154518672wicker
yacked164516792yacked
yakker12405532yakker

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit825511883.17026041.3
3Display Results1881880.0632984.1
 (SQL Overall)1786911883.34353452.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.