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

136 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
gastreas95725(None) 
gastraeas1063571gastraeas
gastrea847221gastrea_
gasters85624292gast_ers
gastness9278472gastness
gastraea954382gastraea
gastral8329552gastr_al
gastrins9310122gastrins
gastrulas1043622gastrulas
wastrels1136202wastrels
actress948533_actress
altheas1038223_altheas
antres65021003_antre_s
areas55935773_a__reas
asterias8317013_asterias
asters65631603_ast_ers
asthmas12117363_asthmas
astral66919283_astr_al
astrals75515243_astrals
astray95615543_astr_ay
basters94930303bast_ers
bastes85330383bast_e_s
bestrews1335603bestrews
bistres94017213bistre_s
casters94729903cast_ers
castes85631863cast_e_s
castles94917733castle_s
costrels1038933costrels
distress9311713distress
easters75125683east_ers
estreat7314813_estreat
estreats839423_estreats
fastens105511753fast_ens
fastness11238763fastness
gagsters10317083gagst_ers
gaiters83516543gait_ers
galateas937133galateas
galeas74618513ga__leas
galeres83514333galere_s
galores82614323galore_s
gambrels1334213gambrels
gangrels1094973gangrels
gantlets9308903gantlets
gantries91413783gantries
garrets84413623ga_rrets
garters84218233gart_ers
gases65633993gas__e_s
gashes105725153gas_he_s
gaskets12348153gas_kets
gasless8319013gas_less
gaspereau1241713gaspereau
gaspers105014133gas_pers
gassers84714633gas_sers
gasses75724783gas_se_s
gasted84821583gast_e_d
gaster75027353gast_e_r
gastric1038633gastr_ic
gastrin839833gastr_in
gastritis1045673gastritis
gastrula953973gastrula
gastrulae1042373gastrulae
gastrular1042763gastrular
gasts66628633gast___s
gateau778113ga_t_eau
gateaus866333ga_t_eaus
gaters74728643ga_t_ers
gates65939513ga_t_e_s
gathers114315073ga_thers
gestes75721393gest_e_s
gesturers1044283gesturers
gestures9310013gesture_s
goitres8389563goitre_s
gumtrees1143883gumtrees
gustless9287683gustless
gustoes879873gustoe_s
hastens106214813hast_ens
hastes95727073hast_e_s
hatreds11307813ha_treds
kestrels1235813kestrels
lapstreak1551973lapstreak
lasters75627693last_ers
latrias71913213la_trias
lustres73013233lustre_s
maltreat1048643maltreat
maltreats1145223maltreats
mantras93815863mantr_as
mastabas1246803mastabas
masters94628923mast_ers
masthead1435883masthead
mastheads1545243mastheads
mastless102610023mastless
matres84522233ma_tre_s
mattress1036533mattress
mistreat10313113mistreat
mistreats1148633mistreats
mistress10310703mistress
nasties73520493nastie_s
onstream1045113onstream
pancreas1235393pancreas
pastas85422873past__as
pastels95215183past_els
pasterns104112623pasterns
pasters94531733past_ers
pastes85233913past_e_s
pasties94529813pastie_s
pastinas103712153pastinas
pastless102411203pastless
pastness102510503pastness
pastries101517423pastries
pasturers1136393pasturers
pastures10311963pasture_s
piastres10249303piastre_s
rasters74629023rast_ers
rasures7312013rasure_s
restress82511773restress
ristras7311563ristr_as
santeras8311063santeras
streak104613623__streak
streaks114411273__streaks
stream84717283__stream
streams94713373__streams
streps86218063__streps
stress66616673__stress
strews96817093__strews
tantras73112093tantr_as
tasters74225643tast_ers
tastes64126423tast_e_s
unstress837373unstress
upstream1243553upstream
vastness11257293vastness
waitress1135223waitress
wasters104026593wast_ers
wastes96224883wast_e_s
wastrel1037553wastre_l
wastries111212883wastries
yantras10259003yantr_as

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621366.62622058.9
3Display Results1361360.0462956.5
 (SQL Overall)1786911366.82826170.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.