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

64 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
einkorn114422(None) 
einkorns1243341einkorns
eikon939462ei_ko_n
inborn8319142_inborn
inkhorn1444362_inkhorn
tinhorn1046032tinhorn
bicorn103610103bi_corn
bighorn1346063bighorn
eikons1038503ei_kons
encore8314773e_ncore
enjoin1357833e_njoin
enorm74415643e_n_orm
hickory1943903hickory
ikon85814953_i_ko_n
inform11310153_inform
inion54620183_inio_n
inker94421093_inker_
inkers104018833_inkers
inkhorns1543583_inkhorns
intern64016543_intern
intort6418923_intort
intown936153_intown
intron64215023_intron
inturn63411563_inturn
inurn53712863_in_urn
jinker174013543jinker_
jinkers183511813jinkers
linker104321473linker_
linkers114317713linkers
linkman1335393linkman
linkmen1335363linkmen
linkwork1444253linkwork
linuron746513linuron
mikron12318503mi_kron
minion83416243minio_n
minor74920063min_or_
minors85117103min_ors
ninon55517383nin_o_n
pinion83815893pinio_n
pinken124513283pink_en
pinker125322443pinker_
pinkers134118603pinkers
pinko115618253pinko__
pinkoes135512313pinkoes
pinkos125313873pinko_s
pinon76024533pin_o_n
pinwork16107243pinwork
pinworm1467183pinworm
pinyon11459763pinyo_n
reinform1346193reinform
sinker103620903sinker_
sinkers113618543sinkers
stinkhorn1642163stinkhorn
tinhorns1145013tinhorns
tinker103619923tinker_
tinkers113517143tinkers
tinwork1476993tinwork
twinborn1341903twinborn
unborn83310813_unborn
unicorn946513unicorn
untorn63012343_untorn
unworn93411333_unworn
winker134220293winker_
winkers143517113winkers

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.406440125.6
2DLD Change Limit134027646.57620381.2
3Display Results64640.0331939.4
 (SQL Overall)178691647.01525472.7
 
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.