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

170 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
linkers11431771(None) 
blinkers14388501blinkers
clinkers14339831clinkers
inkers104018831_inkers
jinkers183511811jinkers
lickers134118251lickers
likers104620911li_kers
liners65428851lin_ers
lingers84223301lingers
linker104321471linker_
linters73822631linters
lunkers113414601lunkers
pinkers134118601pinkers
plinkers14309391plinkers
sinkers113618541sinkers
tinkers113517141tinkers
winkers143517111winkers
aliners74717722alin_ers
bankers133919092bankers
bickers154316552bickers
bikers124517552bi_kers
bilkers134711862bilkers
binders103920742binders
biners85023632bin_ers
bingers104519992bingers
blinders113911142blinders
blinker134110212blinker_
bonkers134015302bonkers
bunkers133715952bunkers
cankers134418752cankers
cinders104617762cinders
clickers163910202clickers
clingers113810662clingers
clinker133811662clinker_
clunkers14327552clunkers
conkers133721042conkers
dickers144117662dickers
dikers114418792di_kers
diners75525952din_ers
dingers94321382dingers
dinkeys15507262dinkeys
dinners83915442dinners
drinkers13277822drinkers
dunkers123512192dunkers
finders113717872finders
fingers113418432fingers
flankers15349302flankers
flickers17338882flickers
flinders12439262flinders
flingers123410192flingers
flunkers15347532flunkers
funkers143712062funkers
gingers94118642gingers
ginners84314222ginners
hankers144218132hankers
hikers135014352hi_kers
hinders113718502hinders
hingers113420212hingers
hinters103719582hinters
honkers143315232honkers
hunkers143314332hunkers
ickers123914182_ickers
infers93615442_infers
inker94421092_inker_
inners63919352_inners
inters64328052_inters
jinker174013542jinker_
junkers184010862junkers
kickers124013292kickers
lackers134120542lackers
lakers105225152l_akers
lancers93616642lancers
landers84026212landers
lanker104123002lanker_
lanners73618332lanners
larkers113014512larkers
leakers113415422leakers
lenders84419642lenders
libbers113812832libbers
libers84721442li_bers
licker125222042licker_
liers55130402li__ers
lifers95617842li_fers
lifters104313782lifters
ligers75022042li_gers
likens105613702li_kens
liker95627062li_ker_
likes96231902li_ke_s
limbers113614742limbers
limmers113413082limmers
limners93311562limners
limpers113815222limpers
lindens839412lindens
linens64818392lin_ens
liner55938922lin_er_
lines57054572lin_e_s
linger75226002linger_
linier64423792linier_
linked114518212linke_d
links96430192link__s
linkups1333632linkups
linnets739832linnets
linseys1035082linseys
lintels73311162lintels
linter64625342linter_
lippers113416442lippers
lispers94514322lispers
listers74026532listers
liters65429882li_ters
litters73422572litters
livers94927822li_vers
liviers104211072liviers
livyers13365902livyers
lockers133516922lockers
loners64225812lon_ers
longers84819542longers
lookers114014072lookers
lungers83817092lungers
lunker104718342lunker_
lurkers113910082lurkers
milkers134411612milkers
mincers113714852mincers
minders103720122minders
miners84126632min_ers
minkes124618782minke_s
minters93822472minters
nickers134415092nickers
pickers153718092pickers
pikers124717392pi_kers
pincers113916502pincers
pinders103720472pinders
pingers104020742pingers
pinkens13419642pinkens
pinker125322442pinker_
pinkeys16378212pinkeys
pinners93518602pinners
plinker134010962plinker_
plunkers14328332plunkers
prinkers143010382prinkers
punkers133714852punkers
rankers113217462rankers
ringers83922952ringers
rinsers73815742rinsers
riskers114011992riskers
singers83824702singers
sinker103620902sinker_
sinners74019022sinners
sinters74024082sinters
skinkers11298182skinkers
slickers143112552slickers
slingers93712682slingers
stinkers123111132stinkers
tankers113416912tankers
thinkers15308702thinkers
tickers133617722tickers
tinders84219172tinders
tinker103619922tinker_
tinklers12298182tinklers
tinners73717312tinners
tinters74221112tinters
wankers144514712wankers
wickers164114702wickers
wincers123415362wincers
winders113721262winders
wingers113921482wingers
winker134220292winker_
winners104316912winners
winters103720482winters
yonkers14379822yonkers
zingers173514852zingers

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 Filter1786911076710.356501941.0
2DLD Change Limit1076711702.87637437.8
3Display Results1701700.0632698.4
 (SQL Overall)1786911703.29554231.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.