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

102 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
estuary103468(None) 
actuary1245612actuary
bestiary1344812bestiary
estray95713332estra_y
ossuary1043942ossuary
ostiary1036462ostiary
textuary1842672textuary
vestiary1444312vestiary
astray95615543astra_y
centaury1343953centaury
century1237193centu_ry
costmary1545053costmary
datary10310243dat_ary
eastward1244993eastward
eatery95316353eat_ery
ecstasy1252603ecst_asy
electuary1443273electuary
enquiry19254043enquiry
entry82414263ent__ry
escar74011993es_car_
escarp10449003es_carp
escars83913133es_cars
eschar1136523eschar_
eschars1237173eschars
escuage1035113escuage
eskar9457453es_kar_
eskars10357593es_kars
esquire16376603esquire
essay867623es_sa_y
estate64719763est_ate
ester54727713est_er_
esters64627733est_ers
estral64716513estra_l
estrays10529403estrays
estrual7367933estrua_l
estuarial943933estuarial
estuaries946213estuaries
estuarine944983estuarine
eustacy1254663eust_acy
eustasy1043873eust_asy
eutaxy1643303eut_axy
gestural946033gestural
gesture839243gestu_re
manuary1237773manuary
mortuary1373923mortuary
nectary1246223nect_ary
notary92310713not_ary
obituary1342853obituary
ostmark1344873ostmark
pessary1246873pes_sary
residuary1342653residuary
restart7320033rest_art
restudy1144763restu_dy
retiary1038333retiary
rotary92411303rot_ary
salary9515213_salary
saury84317223_sau_ry
scary105222593_s_cary
scurry11419593_scurry
sectary1238273sectary
senary93716073_senary
slurry9378603_slurry
smeary114110803_smeary
souari6311383_souari
spurry11429123_spurry
square154513363_square
squark19438113_squark
stagy96618893_st_agy
star48037763_st_ar_
stare54440263_st_are
stark95425623_st_ark
starry94911673_starry
stars55836573_st_ars
start55642313_st_art
statuary1144033statuary
stay78333723_st_a_y
steady103510203_steady
steamy115112373_steamy
story86723033_st_ory
stoury9529943_stoury
strawy1210312823_strawy
stray88525573_stra_y
stubby1345043_stubby
studly10397693_studly
study94411793_stu_dy
stuffy15317083_stuffy
stumpy13458133_stumpy
sturdy1037043_sturdy
sturt56028963_stu_rt
sudary1038703_sudary
sugary1039013_sugary
teary85124053__teary
tertiary1145433tertiary
testacy1235963test_acy
titulary1144873titulary
usury887623us_u_ry
vespiary1642743vespiary
vestry1238623vest__ry
vestural1156473vestural
vesture10310373vestu_re
votary12248333vot_ary
westward1543823westward

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.1731032896.0
2DLD Change Limit1340271026.25021444.3
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.45327691.2
 
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.