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

163 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
galaxies163716(None) 
galaxes1538871galax_es
ataxies142410012_ataxies
galabias1137732galabias
galabieh1444812galabieh
galabiehs1542442galabiehs
gallies84122712gal_lies
maladies11311932maladies
salaries8319572salaries
alanines8314803_alanines
alanins7315803_alanins
alates64833963_ala_tes
alexias14249793_alexias
alexines15258503_alexines
alexins141910663_alexins
alibies9313323_alibies
alkalies12158543_alkalies
alkies104518093_al_kies
allies63827673_al_lies
ataraxies1644723ataraxies
ataxias14189343_ataxias
ataxics16196643_ataxics
balances1279973balances
balases93815433bala_ses
baldies105317703bal_dies
ballies93725743bal_lies
beladies11310423beladies
braxies16711463_braxies
calamines13312223calamines
calamites13410713calamites
calashes13310533calashes
calories102919553calories
calvaries1449803calvaries
calxes154113033cal_x_es
calyxes19426233calyx_es
canaries10318943canaries
claries93422203_claries
dalasis8810533dalasi_s
dallies84023193dal_lies
dataries9314033dataries
eutaxies1545793eutaxies
fallacies1446833fallacies
falsies103515013fal_sies
flaxes165015353_flax_es
flaxier17337983_flaxier
flaxiest18298183_flaxiest
gabies93820733g__abies
gadflies1334733gadflies
gaieties9310183gaieties
galabia1038323galabi_a
galabiya1442753galabiya
galabiyas1542513galabiyas
galagos938143gala_gos
galahs105512673gala__hs
galangas1046173galangas
galantines1145723galantines
galas65731643gala___s
galatea839953gala_tea
galateas937133galateas
galax135314463galax___
galaxy17476313galax__y
galenites10129183galenites
galeres83514333gal_eres
gales65442483gal___es
galettes93111153galettes
galilees936333galilees
gallamines1345493gallamines
gallates92815523gallates
galleins9258693galleins
galleries10311703galleries
gallflies1344223gallflies
gallied94115003gal_lied
galluses936963galluses
galores82614323gal_ores
galoshes1236893galoshes
galvanise1344883galvanise
galvanises1444653galvanises
galvanizes2344763galvanizes
gamashes1456943gamashes
ganaches1437413ganaches
gantries91413783gantries
garages9314113gara_ges
gasalier936443gasalier
gasaliers1044513gasaliers
gasifies1238693gasifies
gaudies9311973ga_udies
gavages1237683gava_ges
gawkies15429123ga_wkies
gayeties1236883gayeties
gazaboes2043863gazaboes
gazanias1845733gazanias
gelates83219583gela_tes
gelatines102910533gelatines
gelatins93414093gelatins
gelatis83313513gelati_s
ghazies2036913g_hazies
gillies84120963gil_lies
glaces94218023g_la_ces
glacier103911293g_lacier
glaciers11277893g_laciers
glacis94012133g_laci_s
glacises1138503g_lacises
glades84820343g_la_des
gladier93810993g_ladier
gladiest101710333g_ladiest
glaires84010133g_laires
glairs75211333g_la_irs
glaives11347833g_laives
glances104113143g_lances
glandes95413833g_landes
glares75518863g_la_res
glarier84112203g_larier
glariest92012523g_lariest
glasses84414273g_lasses
glassies94012273glassies
glazes165315643g_la_zes
glazier17409353g_lazier
glaziers18406563g_laziers
glaziest18227913g_laziest
glories81915913g_lories
goalies8316023g_oalies
gramaries12128303gramaries
granaries10159883granaries
gravies11314093g_ravies
guaranies10127123guaranies
gullies84717313gul_lies
hapaxes1936593hapax_es
jalapins1745623jalapins
jalopies1786673jalopies
ladies75124883__ladies
laxes125430093__lax_es
lazies154418783__lazies
malaise9312673mala_ise
malaises10312333malaises
malarias10313773malarias
malarkies1545113malarkies
malates93522603mala_tes
miladies1139923miladies
palaces114216453pala_ces
paladins11911003paladins
palais8420423pala_i_s
palates93624933pala_tes
palatines11313033palatines
palsies94420273pal_sies
papacies1439473papacies
platies93722543_platies
rallies73823343ral_lies
ratanies8312923ratanies
relaxes143215323relax_es
relaxins15248683relaxins
salamis9313513salami_s
salaried9311023salaried
salifies11314793salifies
sallies73227813sal_lies
salties73725773sal_ties
talkies113415733tal_kies
tallies73624603tal_lies
taxies135817333__taxies
vagaries12310293vagaries
valances1398763valances
walies95324523wal__ies
wallabies1445733wallabies
wallies103320743wal_lies

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621637.47019566.5
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.70623188.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.