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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
gherkin154404(None) 
gherkins1643991gherkins
herein93717792_herein
heroin94420592_heroin
jerkin17258112_jerkin
therein102310352therein
wherein13216592wherein
berlin83116373_berlin
charking183512613charking
checking20379203checking
cheeking18349083cheeking
chervil1534953chervil
chirking18339383chirking
clerking15257163clerking
deerskin1343213deerskin
doeskin1245153doeskin
firkin1337823_firkin
gaskin113610583g_askin
gecking154111363g_ecking
gerbil938343g_erbil
german9611983g_erman
germen9612313g_ermen
germina1038503g_ermina
gharri10386163gharri_
gharris11306433gharris
gherao1036753gher_ao
gheraoing1443523gheraoing
gleeking14316493gleeking
grain65126253g__rain
gremlin1035563gremlin
grin55733723g__r_in
griskin1236013griskin
groin65521083g__roin
guerdon944343guerdon
harken135116343_harken
harking154120943_harking
harmin113117393_harmin
harpin113614383_harpin
hearken14338023_hearken
hemin103620933_he_min
herdic123112303_herdic
herding122915123_herding
hereon93914363_hereon
hermit11519443_hermit
hern76134893_her__n
hernia9312293_hernia
heroic113516923_heroic
heroine103517483_heroine
heroins103518013_heroins
heron85025503_her_on
herring113615883_herring
jerking19308923_jerking
jerkins18358253_jerkins
merlin83916683_merlin
overkind1637953overkind
pekin111514423_pe_kin
perking143716463_perking
pterin81014153pter_in
serein63318463_serein
serin55434443_ser_in
sharking163912973sharking
sherif122915243sher_if
sherris10168803sherris
shirking163210473shirking
smerking15258473smerking
theelin1038003theelin
thein85919023the__in
theremin13107283theremin
thereon10199263thereon
therian10311293therian
thermic1439333thermic
thermion1345933thermion
thermit12312013thermit
theroid11313403theroid
verdin103113023_verdin
vermin113414523_vermin
welkin1337313_welkin
whereon13196503whereon
yerking15368813_yerking

Search took 8 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.830215290.4
2DLD Change Limit134027796.84319586.0
3Display Results79790.0332393.9
 (SQL Overall)178691797.70623188.6
 
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.