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 “oregano” 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
oregano84625(None) 
oreganos945551oreganos
organ6915392or_gan_
organa789212or_gana
organon845912or_ganon
organs7912912or_gans
origan7310692origan_
origans839972origans
beano75421553_be_ano
began86319573_began_
brigand1136643brigand
brogan9311043brogan_
brogans1049663brogans
elegant8311503elegant
forego1038903foreg__o
foregone1238583foregone
forehand1537693forehand
foreland1239013foreland
foreman12312363foreman_
foreran10311793foreran_
forerank1546753forerank
grego7310523greg__o
legato72810953_legato
morgan9311373mor_gan_
morgans10310123mor_gans
ocean71212963oce_an_
oceans81211003oce_ans
omega836383omega__
omegas936973omega_s
operand1038003operand
operant9317223operant
orang65119943or__ang
oread64619603ore_a_d
oreads73915773ore_ads
organdy1254573or_gandy
organic1038313or_ganic
organons945583or_ganons
organum1045343or_ganum
organza1793463or_ganza
orgasm966303or_gasm
orgeat7515033orgea_t
orgeats838353orgeats
orgone71110913or_gone
origami1045453origami
origanum1143393origanum
origin7311033origin_
origins8310463origins
orogeny11107023orogeny
orphan1137733orphan_
orphans1237773orphans
paesano9338793paesano
pregame1239553pregame
pregnant1149883pregnant
preman104117453preman_
rebato83714683_rebato
recane83022873_recane
recant83228683_recant
redan66125013_redan_
redans75421023_redans
regain74517763_regain
regains84316583_regains
regal65023793_rega_l
regale74821453_regale
regard85215773_regard
regave104713383_regave
regent74127673_regent
regina75317143_regina
region74614903_region
regna64614813_reg_na
regnal74812933_regnal
regnant8312843_regnant
regrant8317323_regrant
rehang1039823_rehang
reland75920433_reland
reman75730153_reman_
remand95618963_remand
remans84823003_remans
repand95316063_repand
reran57329103_reran_
rewan85623663_rewan_
romano84912943_romano
segno64814743_seg_no
serrano768463serrano
trepan82511673trepan_
trepang10257293trepang
trepans92311593trepans
vegan95114153_vegan_
vegans103910853_vegans
zingano1744203zingano

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 Filter1786911340270.1401276364.3
2DLD Change Limit134027896.61020276.4
3Display Results89890.0332697.0
 (SQL Overall)178691896.78326343.9
 
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.