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

89 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
jejuna124324(None) 
jejunal1342831jejunal
jejune1233761jejune
jejunum1542082jejunum
ajuga1335883_ajuga
begun85113443begun_
beluga936233beluga
buna64730723__buna
cedula977643cedula
cesura838763cesura
debunk1365113debunk
defund11447983defund
etna46415263_e_tna
fauna84816513_fauna
fecula113310053fecula
fecund1235433fecund
ferula93011173ferula
genua64614153genu_a
gerund836163gerund
hejira1644803hejira
henna84414043he_nna
jacana1537933jacana
jarina134014063jarina
jaunt125025273j_aunt
jean116629283je_an_
jeans126022113je_ans
jeeing144512143jeeing
jehu145614863jehu__
jehus15488573jehu_s
jejunely1741653jejunely
jejunity1742453jejunity
jenny153811623je_nny
jeon116821443je_on_
jerboa1535633jerboa
jesuit1339583jesuit
jeton124815403jeton_
jetons134512613jetons
jeu105532073je_u__
jeux184311273je_u_x
jewing174411423jewing
jnana12159043j_nana
jocund1633623jocund
jojoba1441553jojoba
juba134916983__juba
juga126417323__juga
jugula1434983jugula
juju103612123juju__
jujube1442413jujube
jujus11347463juju_s
jun105932063__jun_
junk155121033__junk
junta123713673__junta
jura116024893__jura
kahuna1394103kahuna
koruna1035483koruna
kuna85120703__kuna
lacuna8118123lacuna
laguna7127223laguna
lehua837953lehu_a
luna46229853__luna
medina94114093medina
medusa936293medusa
melena81110473melena
mezuza1643533mezuza
mizuna1734303mizuna
nebula857333nebula
penna74520203pe_nna
petunia966803petunia
puna65331653__puna
refund104810303refund
regina75317143regina
regna64614813re_gna
rehung1036343rehung
remuda936823remuda
rerun58722153rerun_
reruns66413743reruns
retina65023383retina
retune69121953retune
sauna54117553_sauna
secund937103secund
sejant133114483sejant
semina8915573semina
senna54617983se_nna
tegua6109563tegu_a
tuna45127843__tuna
veena81912323ve_ena
vena76126293ve__na
vicuna11115903vicuna
zenana15297983zenana

Search took 7 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 Filter1786911127160.373479064.3
2DLD Change Limit112716895.58020200.0
3Display Results89890.0302966.7
 (SQL Overall)178691895.98329866.5
 
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.