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 “arugula” 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
arugula84391(None) 
arugola844351arugola
arugulas943911arugulas
argala74712672ar_gala
arugolas944402arugolas
jugula1434982_jugula
rugola736292_rugola
acicula11228133acicula
ajuga1335883ajug__a
alula5317093a__lula
angular838533a_ngular
areola6813673ar_eola
argal65023393ar_gal_
argalas84011093ar_galas
argali75013753ar_gali
argals75517713ar_gals
argil65116883ar_gil_
argils75213623ar_gils
argle65421563ar_g_le
argol65317263ar_gol_
argols74514613ar_gols
argue64818443ar_gu_e
argued84311173ar_gued
arguer74510543ar_guer
argues74516413ar_gues
argufy1344093ar_gufy
argus66716543ar_gu_s
argyle1066063ar_gyle
argyll1033643ar_gyll
armful1167163armful_
armfuls1275013armfuls
armilla936993armilla
artful968273artful_
aucuba1045493a_ucuba
augur64311213a_ugu_r
augural856403a_ugural
augurs7399963a_ugurs
augury10366663a_ugury
august739203a_ugust
aureola747033aureola
auricula1045803auricula
cingula10327173cingula
coagula1045413coagula
cupula10328433_cupula
frenula1045623frenula
frugal1036393frugal_
furcula1245793furcula
jugular1534513_jugular
ligula7359673_ligula
lingula8428803lingula
lunula636173_lunula
neurula744373neurula
plugola1043013plugola
primula1145713primula
radula749313_radula
ranula6311813_ranula
regular838423_regular
reguli738143_reguli
ruga56121233_rug__a
rugal65916093_rugal_
rugolas836373_rugolas
rugosa734563_rugosa
ungula737603_ungula
uvula845153__uvula

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.1401276364.3
2DLD Change Limit134027647.09318895.7
3Display Results64640.0164000.0
 (SQL Overall)178691647.24924650.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.