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

79 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
gelee6362698(None) 
gelees74116261gelees
glee55239061g_lee
melee73729101melee
aglee65728492aglee
alee46652322_alee
allee54932122allee
belie75630382belie
belle75827832belle
celeb9314872celeb
dele56843082del_e
deled75326542deled
deles65139252deles
delete73620702delete
delve96018262delve
else45923082_else
epee64628502_epee
flee76238792_flee
gale56347322gal_e
galea64722932galea
galeae74717452galeae
galere73716672galere
gales65442482gales
gee45359202g__ee
geed65435502ge_ed
geek95327022ge_ek
gees55647882ge_es
geese64316002geese
geez146424862ge_ez
gel45642432gel__
gelate73421252gelate
geld65828432gel_d
gelded94512112gelded
gelder84613712gelder
gelds75118342gelds
gelid74916972gelid
gelled84718892gelled
gels56836102gel_s
gelt56448012gel_t
gelts65924612gelts
gene56237222ge_ne
genes65133092genes
genet66038682genet
genie66124922genie
genre66016802genre
geode7412592geode
geste65920692geste
ghee85726112g_hee
glebe85016442glebe
gled65631142g_led
glede75517832glede
gleed75320572gleed
gleek105315102gleek
glees65027592glees
gleet65532342gleet
gleg66219802g_leg
glen56027202g_len
gley85724652g_ley
glue55628492g_lue
golem8416112golem
gree56641562g_ree
gules64831042gules
helve115018092helve
kelep116014552kelep
lee36068142__lee
levee84023812levee
melees83618082melees
pele65539552pel_e
peles75738082peles
pewee10319972pewee
relet54749822relet
releve95116402releve
resee54336332resee
selle54428312selle
telae54323292telae
tele45040872tel_e
teles54536002teles
telex125214822telex
tepee74724212tepee

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 Filter178691538000.1561145455.1
2DLD Change Limit53800791.97027309.6
3Display Results79790.0302633.3
 (SQL Overall)178691792.15682880.8
 
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.