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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
greenth1111672(None) 
greenths1295211greenths
gerent73223092gerent_
gerents82612922gerents
green65522142green__
greened93111262greened
greener83111712greener
greenie8310122greenie
greenish1247072greenish
greenly11408192greenly
greens75716872green_s
greeny104811452green_y
greet65835322gree_t_
greets75117422gree_ts
ardent73022613ardent_
argent74023663argent_
argents84014853argents
arpent84822093arpent_
arpents93613083arpents
breadth1365993breadth
breath113916263br_eath
breech13348263bree_ch
brent75734133br_ent_
brents84717273br_ents
credent10313973credent_
creesh11328333cree_sh
dozenth2044323dozenth
drench12369593dr_ench
eleventh1443773eleventh
freest95318283freest_
french143511213fr_ench
garment10315233garment_
garments1139963garments
geest64829613g_eest_
geests75912163g_eests
genet66038683g_enet_
genets75716663g_enets
gent56954393g__ent_
gents65729613g__ents
gerenuk1243843gerenuk
gleet65532343glee_t_
gleets75315053glee_ts
gleety10479193glee_ty
grant64840023gr_ant_
grants73722473gr_ants
great66034243gr_eat_
greats76318393gr_eats
gree56641563gree___
greed75125693gree__d
greeds84314283gree_ds
greedy11518853gree_dy
greeing93613783greeing
greek105915943gree__k
greenbug1242633greenbug
greenery12265923greenery
greenest9312623greenest
greenfly1554083greenfly
greenier938713greenier
greenies9312673greenies
greening103112533greening
greenlet948513greenlet
greenlets1044703greenlets
greenlit945803greenlit
greenwash1642403greenwash
greenway1543853greenway
grees65132473gree__s
greeted93111383greeted
greeter82812673greeter
greyest11348343greyest_
greyish1435173greyish
grinch1238473gr_inch
grith95520373gr__ith
growth1377383gr_owth
grunt65523543gr_unt_
grunts75511853gr_unts
orient6322533orient_
orients7311583orients
precent113520263precent_
precents123015043precents
predeath1447003predeath
preen75925053preen__
preened103214993preened
preener93114833preener
preens85020113preen_s
present94022733present_
presents103315643presents
prevent124016553prevent_
prevents133012293prevents
recent83630853_recent_
reenter73217793_reenter
reentry1038033_reentry
reest54938093_reest_
reests64618893_reests
regent74127673_regent_
regents83416543_regents
relent64431853_relent_
relents74018503_relents
rent46661243_r_ent_
rente54733783_r_ente
rents55935183_r_ents
repent84728873_repent_
repents93717623_repents
rerent63832453_rerent_
rerents73319423_rerents
resent63833623_resent_
resents74221223_resents
seventh1336773seventh
teeth87315853_tee_th
tenth85421833__tenth
trecento1066213trecento
treen55622753treen__
treens65317873treen_s
trench114211613tr_ench
umteenth1341623umteenth
urgent73816043urgent_
wreath124111193wr_eath
wrench14439353wr_ench

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 Filter1786911340271.203148537.8
2DLD Change Limit1340271176.72019944.5
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.96922423.3
 
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.