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

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

132 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
geest6482961(None) 
egest65222341egest
gees55647881gees_
geese64316001geese
geests75912161geests
gest56149131g_est
guest65225921guest
reest54938091reest
weest85026771weest
ageist7315382ageist
beast76338642beast
bees65453382bees_
beet66457542bee_t
beets76131442beets
behest11314612behest
beset76739132beset
best66355322_best
blest76431722blest
cees65941592cees_
chest104926142chest
crest74632692crest
dees56356632dees_
deet57356582dee_t
deets65330242deets
deist64633592deist
detest74122842detest
devest104418702devest
doest65829522doest
drest65530342drest
east46659102_east
egesta7428652egesta
egests74411252egests
erst47436432_erst
feast85932722feast
fees76450602fees_
feet75352212fee_t
feist86230072feist
fest74949442_fest
fewest12311662fewest
feyest12311402feyest
freest95318282freest
gaes56348032gaes_
gamest94919922gamest
gast56052562g_ast
gayest104314332gayest
geds66730812geds_
gee45359202gee__
geed65435502gee_d
geek95327022gee_k
geeks104915842geeks
geeky134710732geeky
geez146424862gee_z
gels56836102gels_
gelt56448012g_elt
gelts65924612gelts
gemot84024232gemot
gems75329112gems_
genes65133092genes_
genet66038682genet
genets75716662genets
gens55740072gens_
gent56954392g_ent
gents65729612gents
gerent73223092gerent
gesso649602gesso
geste65920692g_este
gests66028812g_ests
get47467462g_e_t
gets55442482gets_
ghast95621222ghast
ghees95215552ghees_
ghost96318762ghost
gies55641422gies_
gist56046762g_ist
glees65027592glees_
gleet65532342gleet
gleets75315052gleets
glost65422932glost
goes55644092goes_
great66034242great
grees65132472grees_
greet65835322greet
greets75117422greets
greyest11348342greyest
grist65529872grist
guess64213362guess
guests74311202guests
gust55240702g_ust
heist87030912heist
hest75950772_hest
jees115938542jees_
jest116738502_jest
keet85347342kee_t
keets95123482keets
least56134882least
lees45455882lees_
leet45957902lee_t
leets54927122leets
lest46956322_lest
meet65350552mee_t
meets74224612meets
merest84725112merest
neist54628442neist
nest45548732_nest
newest9314212newest
ogees65119142ogees_
pees65257372pees_
pest65555292_pest
prest75736352prest
quest144121322quest
rees45364192rees_
reests64618892reests
renest64529712renest
reset55051862reset
rest46459842_rest
retest64028452retest
revest94623602revest
sees45361052sees_
serest64831612serest
tees45353582tees_
test48651622_test
vees75439432vees_
verst84429372verst
vest75743602_vest
wees76249122wees_
weet75254152wee_t
weets85427722weets
west75748082_west
wrest84925432wrest
yeast85327942yeast
zees136331892zees_
zest136035702_zest

Search took 2 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.296603685.8
2DLD Change Limit538001321.39338621.7
3Display Results1321320.0304400.0
 (SQL Overall)1786911321.719103950.6
 
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.