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

164 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
ganisters1024831(None) 
banisters11189471banisters
canisters112310191canisters
gangsters11205731gangsters
ganister9178991ganister_
gannisters1153841gannisters
banishers14258052banishers
banister10199972banister_
bannisters1244322bannisters
canistels11205392canistels
canister101710852canister_
cannisters1245012cannisters
gagsters10317082ga_gsters
gaiters83516542ga_i_ters
gamesters1236732gamesters
gangster10215772gangster_
gannister1054172gannister_
garnishers14174862garnishers
gasters85624292ga__sters
glisters93912602g_listers
gristers94013402g_risters
lamisters1157122lamisters
magisters1235802magisters
ministers1139622ministers
vanishers15186612vanishers
waisters113811522wa_isters
agonistes10266263agoniste_s
animaters11129973_animaters
aniseeds944393_aniseeds
anises64826693_anis_e_s
anointers937003_anointers
answers1037043_an_swers
assisters936353assisters
asters65631603_a__sters
baiters94619303ba_i_ters
balusters1136643balusters
banisher13169183banisher_
banishes131812463banishe_s
banistered1394623banistered
bannister1155373bannister_
banters94623113ban__ters
barristers1244723barristers
basters94930303ba__sters
batistes1039713batiste_s
bisters93922613__bisters
blisters104015083_blisters
cadasters1236833cadasters
canistel10187253caniste_l
cannister1155723cannister_
canters94827733can__ters
casters94729903ca__sters
cloisters1137433cloisters
dabsters1137053da_bsters
danishes121710493danishe_s
demisters1249203demisters
easters75125683ea__sters
enlisters937113enlisters
fainters11349693fa_inters
filisters1237003filisters
finishers1545353finishers
gagster9317633ga_gster_
gahnites1235703gahni_te_s
gainers84214593ga_i_ners
gainsayers1441873gainsayers
gaiter73819503ga_i_ter_
gamester1137323gamester_
ganders93521703gan__ders
gangbusters1561783gangbusters
gangers94418603gan__gers
gangstas1044403gangst_as
gangsterish1652023gangsterish
gangsterism1552043gangsterism
garnishees14184173garnishees
garnisher13195853garnisher_
garnishes13198813garnishe_s
garotters1055033garotters
garroters1055813garroters
garters84218233ga__rters
gasifiers1344523gasifiers
gaspers105014133ga__spers
gassers84714633ga__ssers
gaster75027353ga__ster_
gaters74728643ga___ters
genistein1042963genistein
genisteins1142723genisteins
genitors937423geni_tors
glistens9366593g_listens
glister84013343g_lister_
glitters93710543g_litters
goiters84014443g_oi_ters
granites92116363grani_te_s
granters93614143gran__ters
grifters12389233g_rifters
grister83915413g_rister_
gritters94210633g_ritters
gunites8313123guni_te_s
gypsters1434023g_ypsters
hamsters13710423ha_msters
heisters113413133_heisters
hoisters113513483_hoisters
igniters9126233igni_ters
insisters997653insisters
janitors1536853jani_tors
kaisers11369273ka_is_ers
keisters123212043_keisters
klisters123910483_klisters
knitters12336623_knitters
lamister1037653lamister_
lamsters1099753la_msters
lasters75627693la__sters
lavishers1564643lavishers
leisters83312823_leisters
listers74026533__listers
magister1136283magister_
maltsters1135193maltsters
manifesters1652753manifesters
masters94628923ma__sters
meisters103313843_meisters
minister10410363minister_
minsters103813923min_sters
misters93927513__misters
monsters103314553mon_sters
munsters104010553mun_sters
nesters74422793__nesters
niters64624213__ni_ters
organisers1143623organis_ers
painters103013023pa_inters
palmisters1444673palmisters
paniers94717333pani__ers
pasters94531733pa__sters
pavisers13387443pavis_ers
pensters103012123pen_sters
pinasters1136823pinasters
plaisters1137813plaisters
planishers1584773planishers
pranksters1653283pranksters
punishers1434973punishers
punsters103310583pun_sters
raisers73617393ra_is_ers
ranters73323643ran__ters
rasters74629023ra__sters
ravishers1564783ravishers
registers1038893registers
resisters9310453resisters
roisters83615553_roisters
sinister838583sinister_
sisters73721593__sisters
snifters11318613_snifters
songsters1046113songsters
spinsters1136613spinsters
tanistry1144543tanist_ry
tanists7313653tanist__s
tapsters10318803ta_psters
tasters74225643ta__sters
twisters11268173_twisters
uniters73814173_uni_ters
vanisher14167453vanisher_
vanishes141610753vanishe_s
varistors1246533varistors
varnishers16174343varnishers
waister103812383wa_ister_
waiters104218623wa_i_ters
wanters104420093wan__ters
wasters104026593wa__sters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411646.48322927.8
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.96925640.8
 
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.