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

112 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
hunky15541773(None) 
chunky18468271chunky
funky154315131funky
gunky135514111gunky
hanky155418291hanky
hinky155618751hinky
honky156218521honky
hulky155312471hulky
hunk116029541hunk_
hunkey164210881hunkey
hunks125321451hunks
husky156112561husky
junky194513231junky
punky144419391punky
aunty85919812aunty
bulky146215572bulky
bunk105731352bunk_
bunko115514512bunko
bunks115125082bunks
bunny104715802bunny
chinky185610542chinky
chucky20418002chucky
chunk144812382chunk_
chunks154210332chunks
clunky15447892clunky
conky145818742conky
dinky135819372dinky
ducky154216112ducky
dumky154511342dumky
dungy104713642dungy
dunk96228572dunk_
dunks105621192dunks
dusky135213042dusky
flunky16408092flunky
funk115825622funk_
funks125318912funks
funny114614832funny
gunk95423572gunk_
gunks104517722gunks
gunny94413662gunny
handy125520872handy
hank115134132hank_
hanks126226862hanks
henry114014472henry
hinny115616672hinny
honey115629912honey
honk116931192honk_
honkey165113822honkey
honks125124522honks
hooky155220262hooky
hubby155011392hubby
huck135927632huck_
hucks144322172hucks
huffy174810232huffy
hulk115321612hulk_
hulks125715482hulks
humpy155115672humpy
hun65844712hun__
hunch136416212hunch
hung86126352hun_g
hungry1334972hungry
hunh106323732hun_h
hunker133917672hunker
hunkeys17386192hunkeys
hunkie133812382hunkie
huns76136932hun_s
hunt76445492hun_t
hunts86826172hunts
hurly115819292hurly
hurry114917182hurry
husk116021952husk_
husks125015452husks
hussy116812762hussy
inky115321582_inky
junk155121032junk_
junks164815972junks
kinky115816382kinky
lanky125517482lanky
linky127622382linky
lucky145515012lucky
lunk86030722lunk_
lunks94822452lunks
luny77324132lun_y
mucky165015252mucky
murky145216682murky
musky144715292musky
pinky145823402pinky
plunky15377952plunky
punk105729972punk_
punka114515482punka
punkey154011172punkey
punks114822682punks
punny104217712punny
punty106021612punty
puny95526992pun_y
quaky214310742quaky
runny84613482runny
runty86119042runty
skunky12436162skunky
spunky15427162spunky
sucky144415502sucky
sulky124715362sulky
sunk85031812sunk_
sunny84917742sunny
thunk124911852thunk_
thunks13459032thunks
tunny86515032tunny
undy85015162_undy
wonky154011772wonky
yucky175411692yucky
yukky14425212yukky
zinky215314812zinky

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001121.70631535.8
3Display Results1121120.0303733.3
 (SQL Overall)1786911121.82997698.7
 
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.