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

122 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
honkers14331523(None) 
bonkers134015301bonkers
conkers133721041conkers
hankers144218131hankers
hockers163915911hockers
honers94324971hon_ers
honker134117461honker_
honkeys17439511honkeys
hookers144916511hookers
hunkers143314331hunkers
yonkers14379821yonkers
bankers133919092bankers
bonders104120662bonders
boners84825432bon_ers
bookers134016612bookers
bunkers133715952bunkers
cankers134418752cankers
chokers164311522cho_kers
cockers153618332cockers
confers124120092confers
congers104223232congers
conker124721552conker_
conners94023112conners
cookers134619462cookers
corkers134118852corkers
dockers143715002dockers
donkeys15426662donkeys
dunkers123512192dunkers
forkers144615782forkers
funkers143712062funkers
goners74420172gon_ers
hackers164619042hackers
handers114224332handers
hangers113120812hangers
hanker134622092hanker_
hawkers174210332hawkers
hikers135014352h_ikers
hinders113718502hinders
hingers113420212hingers
hinters103719582hinters
hoaxers17327132hoaxers
hobbers143512342hobbers
hocker155118562hocker_
hockeys19509272hockeys
hoers85724922ho__ers
hoggers124512482hoggers
hokes126231642ho_ke_s
holders113715902holders
hollers103818232hollers
homers114821972ho_mers
honer85332092hon_er_
hones88144492hon_e_s
honeys124016082hon_eys
honked144517912honke_d
honkey165113822honke_y
honkies143015142honkies
honks125124522honk__s
honorers1139262honorers
honors94816792hon_ors
honours10339372honours
hoofers134513322hoofers
hooker134820172hooker_
hookeys17448952hookeys
hoopers123616482hoopers
hooters104520472hooters
hoovers134312702hoovers
hopers114222972ho_pers
hoppers143115142hoppers
hosers95223962ho_sers
hosiers104212642hosiers
hounders123111712hounders
housers104717812housers
hovers124320252ho_vers
howlers133312352howlers
hungers114013302hungers
hunker133917672hunker_
hunkeys17386192hunkeys
hunters103915732hunters
huskers143510042huskers
inkers104018832_inkers
jinkers183511812jinkers
jokers175511192jo_kers
junkers184010862junkers
linkers114317712linkers
lockers133516922lockers
loners64225812lon_ers
longers84819542longers
lookers114014072lookers
lunkers113414602lunkers
mockers153812942mockers
mongers104217272mongers
monikers1437412monikers
monkery16317452monkery
monkeys16407422monkeys
ockers123813902_ockers
pinkers134118602pinkers
pokers124617922po_kers
ponders103618842ponders
porkers134314932porkers
punkers133714852punkers
rankers113217462rankers
rockers133916552rockers
shockers17319462shockers
sinkers113618542sinkers
soakers114114952soakers
sonders83820712sonders
tankers113416912tankers
thankers15297832thankers
thinkers15308702thinkers
tinkers113517142tinkers
tokers104818892to_kers
toners64128002ton_ers
tongers84116012tongers
tonners73816402tonners
wankers144514712wankers
winkers143517112winkers
wonders113315992wonders
wonners104312812wonners
workers144612692workers
yonker134110852yonker_
younkers15295762younkers
zoners155115992zon_ers

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.373479064.3
2DLD Change Limit1076711223.37631893.1
3Display Results1221220.0304066.7
 (SQL Overall)1786911223.77947285.3
 
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.