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 “gleans” with Change Limit: [1] [2] [3]

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
gleans7501474(None) 
cleans85817051cleans
glans65125831gl_ans
gleams94812251gleams
glean65818201glean_
glens66519851gle_ns
leans55536251_leans
alans55636172al_ans
beans75734692_beans
bleaks125112432bleaks
blears85116452blears
bleats85518612bleats
clans75031012cl_ans
clean75420412clean_
cleanse9358722cleanse
clears84116562clears
cleats84919312cleats
deans66131392_deans
elans55527752el_ans
flans85327972fl_ans
fleams115011942fleams
fleas86423662flea_s
galeas74618502galea_s
galenas83310332galenas
gears64628692g_ears
gelant72821672gelant
gelants82611442gelants
gens55740072g_e_ns
glads75620612gl_ads
glams85822932gl_ams
gland75217712gl_and
glands85314402gl_ands
glass65518132gl_ass
gleam86916732glea_m
gleamy12398112gleamy
gleaned9349422gleaned
gleaner8379772gleaner
gleaners9348072gleaners
glebes95512242glebes
gledes84915132gledes
gleds75417892gle_ds
gleeds84711622gleeds
gleeks11489672gleeks
glees65027592gle_es
gleets75315052gleets
glen56027202gle_n_
gleys96514852gle_ys
glias64618492glia_s
gloams95210662gloams
gloats74515422gloats
glucans1045292glucans
gluons738502gluons
glycans1344232glycans
gobans94412042gobans
gowans105512292gowans
grans64832542g_rans
greats76318392greats
greens75716872greens
groans74815062groans
guans64419442g_uans
jeans126022112_jeans
leads66028492_leads
leafs85721182_leafs
leaks95923912_leaks
lean46345242_lean_
leant56737782_leant
leaps75522932_leaps
learns65513742_learns
lears55938732_lears
leas45954182_lea_s
lemans85316392_lemans
lens46146492_le_ns
loans56026462_loans
means75831222_means
oceans81211002oceans
oleins6313522oleins
paeans85118262paeans
peans75437642_peans
plans75731272pl_ans
pleads94613952pleads
pleas75627032plea_s
pleats85218592pleats
pleons84213342pleons
queans153110752queans
skeans104512912skeans
speans85417142speans
ulans54921302ul_ans
weans85326742_weans
yeans86624882_yeans

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551892.45333653.1
3Display Results89890.0332697.0
 (SQL Overall)178691892.59668833.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.