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

80 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
gherkins164399(None) 
gherkin1544041gherkin_
heroins103518012_heroins
jerkins18358252_jerkins
berlins93216013_berlins
charking183512613charking
checking20379203checking
cheeking18349083cheeking
cherries131812983cherries
chervils1644553chervils
chirking18339383chirking
clerking15257163clerking
deerskins1443203deerskins
doeskins1344903doeskins
firkins1437663_firkins
gaskins123510773g_askins
gecking154111363g_ecking
gerbils1037303g_erbils
germans1079473g_ermans
germens1078633g_ermens
germina1038503g_ermina
gharries12318203gharries
gharris11306433gharri_s
gheraoes1244813gheraoes
gheraoing1443523gheraoing
gleeking14316493gleeking
grains74223093g__rains
gremlins1136053gremlins
grins65427223g__r_ins
griskins1335953griskins
groins73917203g__roins
guerdons1044233guerdons
harkens144112863_harkens
harking154120943_harking
harmins123716723_harmins
harpins123615703_harpins
hearkens15336693_hearkens
hemins113417573_he_mins
herdics13249523_herdics
herding122915123_herding
herein93717793_herein_
hermits12312143_hermits
hernias10310773_hernias
herns84825583_her__ns
heroics122912003_heroics
heroin94420593_heroin_
heroine103517483_heroine
heroines112916573_heroines
herons94820543_her_ons
herries104025073_herries
herring113615883_herring
herrings12379533_herrings
jerkies183411583_jerkies
jerkin17258113_jerkin_
jerking19308923_jerking
merlins93015813_merlins
overkind1637953overkind
pekins121812233_pe_kins
perking143716463_perking
pterins9812993pter_ins
sereins73716123_sereins
serins64029673_ser_ins
sharking163912973sharking
sherifs13299683sher_ifs
sherries111812893sherries
sherris10168803sherri_s
shirking163210473shirking
smerking15258473smerking
theelins1137643theelins
theins95015423the__ins
therein102310353therein_
theremins14106053theremins
therians1138313therians
thermions1445333thermions
thermits1338513thermits
verdins112812333_verdins
welkins1437173_welkins
wherein13216593wherein_
wherries14179023wherries
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 Filter1786911461620.423422437.4
2DLD Change Limit146162806.87321266.1
3Display Results80800.0332424.2
 (SQL Overall)178691807.32924381.4
 
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.