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

190 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
ganister917899(None) 
banister10199971banister
canister101710851canister
gangster10215771gangster
ganisters10248311ganisters
gannister1054171gannister
banisher13169182banisher
banisters11189472banisters
bannister1155372bannister
canistel10187252canistel
canisters112310192canisters
cannister1155722cannister
gagster9317632ga_gster
gaiter73819502ga_i_ter
gamester1137322gamester
gangsters11205732gangsters
gannisters1153842gannisters
garnisher13195852garnisher
gaster75027352ga__ster
glister84013342g_lister
grister83915412g_rister
lamister1037652lamister
magister1136282magister
minister10410362minister
sinister838582sinister
vanisher14167452vanisher
waister103812382wa_ister
agisted938203_agisted
aglitter935093aglitter
agonistes10266263agonistes
animater101512393_animater
anise55129703_anis_e_
aniseed839403_aniseed
anises64826693_anis_es
anointer837823_anointer
answer936893_an_swer
antsier7410773_antsier
assister836753assister
aster55434893_a__ster
baiter84422553ba_i_ter
baluster1037053baluster
banished14189063banished
banishers14258053banishers
banishes131812463banishes
banistered1394623banistered
bannisters1244323bannisters
banter84825333ban__ter
barrister1145733barrister
baster85333593ba__ster
batiste939743batiste_
batistes1039713batistes
bister84922763__bister
blister94415313_blister
cadaster1136903cadaster
canistels11205393canistels
cannisters1245013cannisters
canter85230113can__ter
caster85232573ca__ster
cloister1037093cloister
dabster1036703da_bster
danishes121710493danishes
demister11310223demister
easter65027983ea__ster
enlister847803enlister
fainter103611053fa_inter
faster94625773fa__ster
filister1137403filister
finisher1436303finisher
gagsters10317083ga_gsters
gahnite1135973gahni_te_
gahnites1235703gahni_tes
gainer74117493ga_i_ner
gainlier965673gainlier
gainsayer1342133gainsayer
gainst74914703gainst__
gaited84416923ga_i_ted
gaiters83516543ga_i_ters
gamesters1236733gamesters
gamier93617933gami__er
gander84322763gan__der
gangbuster1451963gangbuster
ganger83721463gan__ger
ganglier1047603ganglier
gangsta944513gangst_a
gangstas1044403gangstas
garnished14196143garnished
garnishee13185763garnishee
garnishers14174863garnishers
garnishes13198813garnishes
garotter965943garotter
garroter956573garroter
garter74420513ga__rter
gasher104320373ga__sher
gasifier1236273gasifier
gasper94515543ga__sper
gasser75017773ga__sser
gassier83812573ga_ssier
gasted84821583ga__sted
gasters85624293ga__sters
gater64533653ga___ter
gaunter82910713ga_unter
genistein1042963genistein
genitor837273geni_tor
glisten8418083g_listen
glisters93912603g_listers
glitter84211803g_litter
goiter74116203g_oi_ter
granite82017083grani_te_
granites92116363grani_tes
granter84117133gran__ter
grifter113810493g_rifter
gristers94013403g_risters
gritter83913353g_ritter
gunite7414403guni_te_
gunites8313123guni_tes
gypster1333953g_ypster
hamster12810423ha_mster
heister103613623_heister
hoister103714203_hoister
honester1139713honester
igniter8147673igni_ter
insister888783insister
janitor1436483jani_tor
kaiser103610373ka_is_er
keister113011573_keister
klister113410643_klister
knitter11348133_knitter
lamisters1157123lamisters
lamster9109913la_mster
laster64830633la__ster
lavisher1445083lavisher
leister73212753_leister
lister64527253__lister
magisters1235803magisters
maltster1035303maltster
manifester1543133manifester
master84831343ma__ster
meister93114163_meister
ministers1139623ministers
minster93914323min_ster
mister84728563__mister
moister94015373_moister
monster93214603mon_ster
munster93710523mun_ster
nester64124183__nester
niter55028973__ni_ter
organiser1045483organis_er
painter93814563pa_inter
palmister1345053palmister
panier84425503pani__er
paster85734373pa__ster
paviser12489093pavis_er
penster92811953pen_ster
pinaster1037113pinaster
plaister1068013plaister
planisher1495853planisher
prankster1543183prankster
punisher1335773punisher
punster92911103pun_ster
raiser66620103ra_is_er
ranter63826823ran__ter
raster64731443ra__ster
ravisher1465463ravisher
register939553register
resister8311653resister
roister73516203_roister
sister64421583__sister
snifter10349623_snifter
songster935793songster
spinster1036683spinster
tanist6324593tanist__
tanistry1144543tanistry
tanists7313653tanist_s
tapster9299273ta_pster
taster64930573ta__ster
twister10308953_twister
uniter64619143_uni_ter
vanished15207743vanished
vanishers15186613vanishers
vanishes141610753vanishes
varistor1146393varistor
varnisher15195403varnisher
vaster94521023va__ster
waisted114210943wa_isted
waisters113811523wa_isters
waiter94321253wa_i_ter
wanier93920683wani__er
wanter94423053wan__ter
waster95228943wa__ster
zanier154314713zani__er

Search took 9 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.483369960.7
2DLD Change Limit1461621907.59319249.6
3Display Results1901900.0802375.0
 (SQL Overall)1786911908.15621909.1
 
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.